MySql 这条查询语句有问题吗?
贫下码农 2015-04-02 11:02:19 一条查询语句两种写法:
1:select id,name from TableName
2:select [id],[name] from TableName
这两条语句在mssql或sqlite是没问题的,但在mysql里第2条就报错:
You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version
for the right syntax to use near '[id],[name] from TableName' at line 1
在mssql select 语句中有些字段可能是关键字,加了[]中括号是为了防止歧义,用来区分字段名还是关键字,
难道mysql 没有歧义不用区分字段名还是关键字吗?
求解!!!