Question

sql 语句insert into执行不成功，帮看看错在哪里！？

语句如下，怎么看也看不出来错误。可就是执行不成功。
INSERT INTO `feedback` (username,uid,arcarea,type,dtime,ischeck,msg,ip,isdel,isaccept,title,name,sex,age,mail,add,pri,tell,pro,lb,fanchou,num,pwd) VALUES ('test',1,'all','all',1436774656,0,'msg','125.40.213.121',0,0,'title','name','sex',12,'mail','add',1,1231231,'pro','lb','fanchou','1436774656542ba9084c9ab7734396941380f93246',421981);
直接对表执行的查询语句。错误提示是下面：
[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 'add,pri,tell,pro,lb,fanchou,num,pwd) VALUES ('test',1,'all','all',1436774656,0,'' at line 1
自己找到原因了，name字段和add字段是应该是和sql语句的语法有重复，所以无法执行。

Answer 1

有些关键字要加中括号 name 不清楚是不是的 但最好加上,add也加上
'feedback' 改成feedback

Answer 2

减少一些字段，来测试。