You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

最新推荐文章于 2024-07-27 14:50:38 发布

面向甲方编程

最新推荐文章于 2024-07-27 14:50:38 发布

阅读量2.1k

点赞数

分类专栏：后端文章标签： mysql

本文链接：https://blog.csdn.net/weixin_44519961/article/details/88886854

版权

后端专栏收录该内容

2 篇文章 0 订阅

订阅专栏

CREATE TABLE ‘yuedu_members’ (
‘u_id’ int(11) NOT NULL AUTO_INCREMENT COMMENT ‘用户id’,
‘u_openid’ varchar(100) NOT NUll COMMENT ‘openid’,
‘u_name’ varchar(60) NOT NULL COMMENT ‘用户昵称’,
‘u_face’ varchar(200) NOT NULL COMMENT ‘用户头像’,
‘u_random’ varchar(30) NOT NULL COMMENT ‘用户随机码’,
‘u_integral’ int(10) DEFAULT ‘0’ COMMENT ‘积分’,
‘u_remainder’ int(10) DEFAULT ‘0’ COMMENT ‘余额’,
‘u_regtime’ int(11) NOT NULL COMMENT ‘用户注册时间’,
PRIMARY KEY(‘u_id’),
UNIQUE KEY ‘u_openid’ (‘u_openid’),
UNIQUE KEY ‘u_id’ (‘u_id’)
) ENGINE=InnoDB AUTO_INCREMENT =1 DEFAULT CHARSET=utf8mb4;

报错：#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 '‘yuedu_members’ ( ‘u_id’ int(11) NOT NULL AUTO_INCREMENT COMMENT ‘用户id’, ’ at line 1

CREATE TABLE yuedu_members (
u_id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘用户id’,
u_openid varchar(100) NOT NULL COMMENT ‘openid’,
u_name varchar(50) NOT NULL COMMENT ‘用户昵称’,
u_face varchar(200) NOT NULL COMMENT ‘用户头像’,
u_random varchar(30) NOT NULL COMMENT ‘用户随机码’,
u_integral int(10) DEFAULT ‘0’ COMMENT ‘积分’,
u_remainder int(10) DEFAULT ‘0’ COMMENT ‘余额’,
u_regtime int(11) NOT NULL COMMENT ‘用户注册时间’,
PRIMARY KEY (u_id),
UNIQUE KEY u_openid (u_openid),
UNIQUE KEY u_id (u_id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;