求帮助,关于MYSQL插入数据失败问题
楼主是跟着书做的美食天下那个项目,数据库这里插入总是错误,是怎么回事?
我工具是用的Navicat for MYSQL ,表已经建好,
共有两句提示,提示如下:
…………………………………………………………………………………………………………………………
一、
[SQL] EXPLAIN INSERT INTO mstx_head (tid, tname, tdis, uid)
VALUES
(
0,
"默认头像",
"这是个默认的头像,并没有数据",
0
);
[Err] 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 'INSERT INTO mstx_head (tid, tname, tdis, uid)
VALUES
(
0,
"默认头像' at line 1
……………………………………………………………………………………………………………………………………
二、
[SQL] EXPLAIN INSERT INTO mstx_user (
uid,
u_name,
u_qq,
u_Email,
u_dis,
u_head,
u_pwd,
u_admin,
u_mood,
u_integral,
u_hobby,
u_level,
u_number
)
VALUES
(
0,
"管理员账号",
"250178767",
"250178767@qq.com",
"这是个测试管理用户",
0,
111,
TRUE,
"快乐",
376,
"电脑",
3,
23
);
[Err] 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 'INSERT INTO mstx_user (
uid,
u_name,
u_qq,
u_Email,
u_dis,
u_head,
' at line 1
……………………………………………………………………………………………………………………
提示在某行错误,可是我不清楚到底是哪里错误,楼主是新人,请说清楚些,谢谢了