这个简单的插入操作
INSERT INTO `user`(phone_num,PASSWORD,e-mail,username,uid)
VALUES ('1234567','test','test','[email protected]',3)执行然后就出错了[SQL] INSERT INTO `user`(phone_num,PASSWORD,e-mail,username,uid)
VALUES ('1234567','test','test','[email protected]',3)[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 '-mail,username,uid)
VALUES ('1234567','test','test','[email protected]',3)' at line 1
INSERT INTO `user`(phone_num,PASSWORD,e-mail,username,uid)
VALUES ('1234567','test','test','[email protected]',3)执行然后就出错了[SQL] INSERT INTO `user`(phone_num,PASSWORD,e-mail,username,uid)
VALUES ('1234567','test','test','[email protected]',3)[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 '-mail,username,uid)
VALUES ('1234567','test','test','[email protected]',3)' at line 1
VALUES ('1234567','test','test','[email protected]',3)
VALUES ('1234567','test','test','[email protected]',3)主要的问题应该还是在e-mail里,中间的-可能被当成减号了,写成`e-mail`试试