今天在写SQL,创建table的时候,出了点小问题,报错: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 'rank char(1))' at line 6, Time: 0.000000s,原代码如下
create table grade(
low int(3),
upp int(3),
rank char(1));
网上搜到的都是关于分隔符的原因,然后辗转几个群,有大佬给出的原因是关键词的问题,尝试了下,果然解决,更改后的代码如下:
create table grade(
low int(3),
upp int(3),
`rank` char(1));