mysql 关键字

mysql中，建表字段名和查询语句中，尽量不要使用mysql关键字，如group,index等

如查询语句：select index from table1 limit 1\G;

则报如下错误:

ERROR 1064 (42000): 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 'index from table1' at line 1

如果是 select index1 from table1 limit 1\G;

ERROR 1054 (42S22): Unknown column 'index1' in 'field list'