mySQl 插入现有表语法错误

Question

我试图在“员工”表中添加这些值，但它显示了一个我无法修复的错误，有帮助吗？!

语法:

INSERT INTO `employee`( 'UserName',`ID`, `firstname`, `middlename`,'lastname','Address','department','salary','password','phonenumber','email','LoginStatus') 
VALUES ('medo',1','ahdjh','rgetrhytyiu','rgthyu','','2','100000','','24741585285','da@hash.com','1')

错误:

Error: INSERT INTO employee( 'UserName',ID, firstname, middlename,'lastname','Address','department','salary','password','phonenumber','email','LoginStatus') VALUES ('medo',1','ahdjh','rgetrhytyiu','rgthyu','','2','100000','','24741585285','da@hash.com','1') 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 ''UserName',ID, firstname, middlename,'lastname','Address','department','sa' at line 1

Answer 1

试试这个:从列中删除引号--

INSERT INTO employee( UserName,ID, firstname, middlename,lastname,Address,department,salary,password,phonenumber,email,LoginStatus) VALUES ('medo',1','ahdjh','rgetrhytyiu','rgthyu','','2','100000','','24741585285','da@hash.com','1')