Search code examples
mysqlmysql-workbenchinsert-into

MySQL Workbench expecting command between table name and columns

I'm using MySQL Workbench, as part of automating adding and updating information to my table I'm using a statement like the following.

INSERT INTO table_name(ID,Name,Location) VALUES (1232346, 'Bob', 'France')

I've been looking at the reference manual online for my version of the program (5.6.15) and according to that there shouldn't be need for anything additional in my statement. But when I put it into the SQL query it gives me an error at the first bracket that...

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

What can I do to fix this?

Solution

  • Turns out there were two things wrong with my original. The first was that there was a typo with one of my column names. The second was that there was a different number of columns and values that I had given.