It is really simple but I am unexperienced in SQL, and also I have no idea why this syntax error occurs. Any help is appreciated.
它非常简单,但我对SQL没有经验,而且我也不知道为什么会出现这种语法错误。任何帮助表示赞赏。
INSERT INTO "zr_mem"('email', 'pwd', 'code') VALUES ('test@test.com','213123','324')
Thanks in advance.
提前致谢。
3 个解决方案
#1
3
You have to use backticks instead of single quotes:
你必须使用反引号而不是单引号:
INSERT INTO zr_mem(`email`, `pwd`, `code`) VALUES
('test@test.com','213123','324')
#2
3
you have to use backticks (below key of Esc key) instead of ''
你必须使用反引号(在Esc键的下面)而不是''
INSERT INTO zr_mem(`email`, `pwd`, `code`) VALUES ('test@test.com','213123','324')
100% working ☺
100%工作☺
#3
1
This is the right way:
这是正确的方法:
insert into `zr_mem`(email,pwd,code) values('test@test.com','$213123','324')
#1
3
You have to use backticks instead of single quotes:
你必须使用反引号而不是单引号:
INSERT INTO zr_mem(`email`, `pwd`, `code`) VALUES
('test@test.com','213123','324')
#2
3
you have to use backticks (below key of Esc key) instead of ''
你必须使用反引号(在Esc键的下面)而不是''
INSERT INTO zr_mem(`email`, `pwd`, `code`) VALUES ('test@test.com','213123','324')
100% working ☺
100%工作☺
#3
1
This is the right way:
这是正确的方法:
insert into `zr_mem`(email,pwd,code) values('test@test.com','$213123','324')