Mysql8的坑

我们来看一下这一段代码,看起来没问题对吧 CREATE TABLE 'userDatas' ( 'id' INT ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMIT '主键 自增长', 'name' VARCHAR ( 15 ) NOT NULL COMMIT '不为空', 'telephone' VARCHAR ( 11 ) NOT NULL COMMIT '手机号 不为空 唯一', 'age' VARCHAR ( 3 ) NULL COMMIT '可空', PRIMARY KEY ( 'id' ), UNIQUE KEY ( 'telephone' ) );

1 CREATE

TABLE

'userDatas'

( 2

'id'

INT

(

10

)

UNSIGNED

NOT

NULL AUTO_INCREMENT COMMIT '主键 自增长' , 3

'name'

VARCHAR

(

15

)

NOT

NULL COMMIT '不为空' , 4

'telephone'

VARCHAR

(

11

)

NOT

NULL COMMIT '手机号 不为空 唯一' , 5

'age'

VARCHAR

(

3

)

NULL COMMIT '可空' , 6

PRIMARY KEY (

'id'

) , 7

UNIQUE KEY (

'telephone'

)

8 ) ; CREATE TABLE 'userDatas' ( 'id' INT ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMIT '主键 自增长', 'name' VARCHAR ( 15 ) NOT NULL COMMIT '不为空', 'telephone' VARCHAR ( 11 ) NOT NULL COMMIT '手机号 不为空 唯一', 'age' VARCHAR ( 3 ) NULL COMMIT '可空', PRIMARY KEY ( 'id' ), UNIQUE KEY ( 'telephone' ) ) > 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 ''userDatas' ( 'id' INT ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMIT '主键 è' at line 1 > 时间: 0.004s

11

1 CREATE

TABLE

'userDatas'

( 2

'id'

INT

(

10

)

UNSIGNED

NOT

NULL AUTO_INCREMENT COMMIT '主键 自增长' , 3

'name'

VARCHAR

(

15

)

NOT

NULL COMMIT '不为空' , 4

'telephone'

VARCHAR

(

11

)

NOT

NULL COMMIT '手机号 不为空 唯一' , 5

'age'

VARCHAR

(

3

)

NULL COMMIT '可空' , 6

PRIMARY KEY (

'id'

) , 7

UNIQUE KEY (

'telephone'

)

8 ) 9

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 '' userDatas ' ( 10

' id ' INT ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMIT ' 主键 è ' at line 1 11

时间: 0.004s ??? 一看原来是表名和字段名使用的开始结尾符号 是"`"而不是"'".....