CREATE TABLE 'payment'(
'id' BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
'serial' VARCHAR(200) DEFAULT'',
PRIMARY KEY('id')
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
报错:
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 ‘‘payment’(
‘id’ BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT ‘ID’,
‘serial’ VARCHA’ at line 1
CREATE TABLE `payment`(
`id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`serial` VARCHAR(200) DEFAULT'',
PRIMARY KEY(`id`)
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
原因:标点符号弄错了把 ’ 改成------> `