Posted at

SQL | AS works even if it is not

The following are both the same.


A world with AS

 SELECT 'Alice' AS alice, 'Bob' AS bob ; 


A world without AS

 SELECT 'Alice' alice, 'Bob' bob ; 


result

 +-------+-----+ | alice | bob | +-------+-----+ | Alice | Bob | +-------+-----+ 


environment


  • mysql Ver 14.14 Distrib 5.7.12, for osx 10.11 (x86_64) using EditLine wrapper


Original by

SQL | AS は実はなくても動く


About

About this translattion