What's wrong with this SQL query?

Question

I seem to be going wrong somewhere in this INSERT query. Can someone tell me how to make this work?

Thanks.

INSERT INTO tablename ('score', 'coins-earned', 'bonus-used', 'topmultiplier', 'highscore', 'currentposition', 'super', 'star', 'color') 
VALUES ('1', '2', 'TRUE', '3', 'TRUE', '4', '5', '6', '7') 

Answer 1

Then Syntax itself is ok.

Please add the table description, there must be an error regarding the values you want to put into the table (maybe numeric and you want to insert "TRUE").

Answer 2

Please provide the table structure.

I guess 'score' is numeric and you are trying to insert a string and so is the case with many other columns.

Answer 3

i guess the numbers are numeric values in the table design, so you won't need the '' - and if the column "bonus-used" is a bit/bool column use 1/0 and not 'true'

so

values (1,2,1,3,1,4,5,6,7)

Answer 4

You're putting column names in quotes, and hyphens are probably invalid in column names. In MS SQL, this is valid:

INSERT INTO tablename (score, [coins-earned], [bonus-used], 
    topmultiplier, highscore, currentposition, super, star, color) 
VALUES ('1', '2', 'TRUE', '3', 'TRUE', '4', '5', '6', '7') 

That also assumes that all the columns are char or varchar, which they're probably not. Numeric and boolean columns don't want quotes either, so it's possible you'll end up with something like this:

INSERT INTO tablename (score, [coins-earned], [bonus-used], 
    topmultiplier, highscore, currentposition, super, star, color) 
VALUES (1, 2, TRUE, 3, TRUE, 4, '5', '6', '7') 

Answer 5

Try to replace the single quotes from the column names:

INSERT INTO tablename
  (`score`, `coins-earned`, `bonus-used`, `topmultiplier`,
   `highscore`, `currentposition`, `super`, `star`, `color`) 
VALUES ('1', '2', 'TRUE', '3', 'TRUE', '4', '5', '6', '7')