Error when inserting in to MySQL

Question

#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 ''users' (username, password, first_name, last_name, email) VALUES ('ri' at line 1

INSERT INTO 'users' (`username`, `password`, `first_name`, `last_name`, `email`) VALUES ('rikars', '5aa9d6460f4ada3eb6611d6fda437317', 'Arsen', 'Babajanyan', 'rikarsenbabajanyan@gmail.com')

why downvote? it's a mistake in the code, like almost all the questions in SoF — jcho360, Jan 15 '14 at 14:38

score 3 · Accepted Answer · edited Jan 15 '14 at 14:39

3

Your table name cannot be in quotes. You can and should use ticks, however:

INSERT INTO `users`
            (`username`, 
             `password`, 
             `first_name`, 
             `last_name`, 
             `email`) 
VALUES      ('rikars', 
             '5aa9d6460f4ada3eb6611d6fda437317', 
             'Arsen', 
             'Babajanyan', 
             'rikarsenbabajanyan@gmail.com')

edited Jan 15 '14 at 14:39

Kermit

33,827
13
85
121

answered Jan 15 '14 at 14:35

John Conde

217,595
99
455
496

Trying to make it a habit when I answer low quality questions – John Conde Jan 15 '14 at 14:38

Error when inserting in to MySQL

1 Answers1