What is wrong with the syntax near 'id'?

Question

  CREATE TABLE post(
   'id' int UNSIGNED AUTO_INCREMENT,
   'title' VARCHAR(100),
   'content' VARCHAR(5000),
   'writer' VARCHAR(100),
   'updated_at' TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   'created_at' DATETIME DEFAULT NULL,
   PRIMARY KEY(id)
  );

#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 ''id' int UNSIGNED AUTO INCREMENT, 'title' VARCHAR(100), 'content' VARCHAR(5000' at line 2

Does this answer your question? [When to use single quotes, double quotes, and backticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql) — Dharman, Jul 03 '21 at 16:38

score 3 · Accepted Answer · answered Dec 22 '11 at 21:14

3

Field names need to be wrapped in backtics - quotes will cause an error.

So,

`id` int UNSIGNED AUTO_INCREMENT,
`title` VARCHAR(100),

etc.

answered Dec 22 '11 at 21:14

Pekka

442,112
142
972
1,088

+1 Or leave the backtics out completely. They hurt my eyes when they're unnecessary. – Joe Stefanelli Dec 22 '11 at 21:18
Thanks mate I accidently clicked -1. Don't mind it. Your answer is great! It worked! – Isuru Dec 22 '11 at 21:22
I will +1 it. Just give me some time. – Isuru Dec 22 '11 at 21:23
@isuru you're welcome. Don't worry, I'm not seeing a -1, I don't think it applied. – Pekka Dec 22 '11 at 21:24
@isurumadusanka Be sure to accept the answer as well by clicking on the outlined check mark next to it. – Joe Stefanelli Dec 22 '11 at 21:26

What is wrong with the syntax near 'id'?

1 Answers1