SQL Query unable to create database

Question

CREATE TABLE IF NOT EXISTS 'users'(
'id' INT(10) NOT NULL AUTO_INCREMENT,
'username' VARCHAR(70) NOT NULL,
'password' VARCHAR(40) NOT NULL,
'email' VARCHAR(50) NOT NULL,
 'created_at' DATETIME NOT NULL,
 'updated_at' DATETIME DEFAULT NULL,
  PRIMARY KEY('id'),
  UNIQUE KEY 'email'('email')
  ) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;

Error : A symbol name was expected! (near "'id'" at position 39) At least one column definition was expected. (near "'id'" at position 39) Unexpected beginning of statement. (near "10" at position 48) Unrecognized statement type. (near "NOT NULL" at position 52)

Possible duplicate of [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) — Jens, Jun 21 '17 at 07:02
You should use backtics and not single quote around the column name — ScaisEdge, Jun 21 '17 at 07:07

score 0 · Accepted Answer · answered Jun 21 '17 at 07:07

0

Use backticks instead of single quotes.
` instead of- '

answered Jun 21 '17 at 07:07

Keyur Panchal

1,382
1
10
15

SQL Query unable to create database

1 Answers1