mysql查询结果列名都是大写_为什么MySQL查询几乎总是以大写形式编写

I've seen most coders use Capital letters while writing MySQL queries, something like

"SELECT * FROM `table` WHERE `id` = 1 ORDER BY `id` DESC"

I've tried writing the queries in small caps and it still works.

So is there any particular reason for not using small caps or is it just a matter of choice?

解决方案

It's just a matter of readability. Keeping keywords in upper case and table/column names lower case means it's easier to separate the two when scan reading the statement .: better readability.

Most SQL implementations are case-insensitive, so you could write your statement in late 90s LeEt CoDeR StYLe, if you felt so inclined, and it would still work.