MySQL INSERT INTO - "(" is not valid at this position

Question

I'm trying to insert data in to my 'command' table where 'trigger' and 'desc' are not null varchar(255) and there is an int 'id' primary key set to auto increment.

MySQL workbench is throwing an error for the open parentheses after 'command':

"(" is not valid at this position for this server version, expecting: VALUE, SELECT, SET, VALUES, WITH

For any insert query I attempt e.g:

INSERT INTO command('trigger','desc') VALUES("value","value");

This is likely a really simple error on my part but I can't seem to spot what is wrong here, any ideas?

Fix the single quotes. – Gordon Linoff Jan 19 '19 at 02:39 — Gordon Linoff, Jan 19 '19 at 02:39

jonroethke · Accepted Answer · 2019-01-19T02:46:55.427

7

Desc & trigger are reserved words, so they can't be used as column names unless you use backticks. See this post for further explanation.

Once this is resolved, the SQL query is also incorrectly formatted as the column names should not be surrounded by quotes.

Use the following as a guide:

INSERT INTO command (`trigger`, `desc`) VALUES ('value', 'value');

edited Jan 19 '19 at 02:46

answered Jan 19 '19 at 02:29

jonroethke

1,152
2
8
16

That worked, cheers! I also had to use backticks on `trigger` for the query to work, is that a reserved word too? – user7466895 Jan 19 '19 at 02:39
Ah yeah, good catch. Probably a good idea not to use reserved words as col names – jonroethke Jan 19 '19 at 02:46

MySQL INSERT INTO - "(" is not valid at this position

1 Answers1