Mysql中当表名为关键字时的处理方法
报错SQL语句:
insert into order values(null,'小辰哥哥',18);
[Err] 1064 - 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 'order values(null,'小辰哥哥',18)' at line 1
原因:
表名order使用了mysql的关键字,需要把order用"`"括起来,就是Tab键上面的键
解决SQL语句:
insert into `order` values(null,'小辰哥哥',18);
总结
每天一个提升小技巧!!!