Mysql error in my syntax

Question

Hey i have an error in my mysql syntax, and i dont know why i get it. I can't see an error in my code and i have checked the web for help...

    INSERT INTO downloads_log 
    (file,by,time) VALUES
    (1,1, NOW())

The error:

'SQLSTATE[42000]: Syntax error or access violation: 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 'by, time) VALUES (1,1,NOW())

the syntax highlighter tells it all, `by` is a reserved word and you need to wrap that inside `` — Abhik Chakraborty, Feb 05 '16 at 09:41

Jenz · Accepted Answer · 2016-02-05T09:46:44.957

2

by,file and time are reserved keywords used in MYSQL. Use a back tick (`) to escape the keywords in your query. Change your query to :

INSERT INTO downloads_log 
    (`file`,`by`,`time`) VALUES
    (1,1, NOW())

edited Feb 05 '16 at 09:46

answered Feb 05 '16 at 09:41

Jenz

8,172
7
41
75

score 2 · Answer 2 · answered Feb 05 '16 at 09:41

2

by is a reserved keyword. Try:

INSERT INTO downloads_log 
(`file`, `by`, `time`) VALUES
(1, 1, NOW())

answered Feb 05 '16 at 09:41

Kevin Robatel

7,570
3
41
56

score 1 · Answer 3 · answered Feb 05 '16 at 09:41

1

You're using reserved keywords as column names. Try to avoid using reserved keywords as column names, but if you haven't choice you have to pass them to backticks `` in following:

INSERT INTO downloads_log (`file`,`by`,`time`) VALUES (1,1, NOW())

answered Feb 05 '16 at 09:41

Stanislovas Kalašnikovas

8,935
4
29
59

Mysql error in my syntax

3 Answers3