MySQL - Syntax Error

Question

what am I doing wrong with this query:

INSERT INTO 'stats' ('uuid', 'kills', 'deaths', 'games', 'beststreak') VALUES ('5dbef8c9-977a-3ddf-b732-473be6318596', '0', '0', '0', '0')

Here you can see the strutcture of my table:

The error:

[15:11:23 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ''stats' ('uuid', 'kills', 'deaths', 'games','beststreak') VALUES ('5dbef8c9-977' at line 1

hjpotter92 · Accepted Answer · 2014-06-22 13:24:38Z

6

The table and column names should be enclosed either in backticks, or left alone. They shouldn't be enclosed in single or double quotes.

Also, since the last 4 columns are type INT, you don't need to pass 0 as strings either.

INSERT INTO `stats` (
    `uuid`,
    `kills`,
    `deaths`,
    `games`,
    `beststreak`
)
VALUES (
    '5dbef8c9-977a-3ddf-b732-473be6318596',
    0,
    0,
    0,
    0
)

answered Jun 22, 2014 at 13:24

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Conde · Accepted Answer · 2014-06-22 13:24:29Z

3

Get rid of the quotes around your table name and column identifiers. Use ticks or nothing.

INSERT INTO stats (uuid, kills, deaths, games, beststreak) 
VALUES ('5dbef8c9-977a-3ddf-b732-473be6318596', '0', '0', '0', '0')

or

INSERT INTO `stats` (`uuid`, `kills`, `deaths`, `games`, `beststreak`) 
VALUES ('5dbef8c9-977a-3ddf-b732-473be6318596', '0', '0', '0', '0')

answered Jun 22, 2014 at 13:24

John Conde

220k100 gold badges464 silver badges504 bronze badges

Collectives™ on Stack Overflow

MySQL - Syntax Error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related