先搭建的mysql,创建表的时候出现异常,语句如下:
CREATE TABLE 'users1'(
'id' int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY ('id')
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
出现语法异常。
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
解决方法:
①去掉表明和字段的单引号。
CREATE TABLE user1(
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
②单引号改成键盘Tab上一个按键·
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;