CODEWITHSUNDEEP
mysql
kaa
kaa

Reputation: 1367

MySQL error when quoting `identifiers`

Somehow I can't use quotes in queries.
For example, a simple query:

create table `T1`( `f1` integer );

Gives an error:

Error Code: 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 '`T1`( `f1` integer )' at line 1.

Why does this happen?
I'm using MySQL server 5.5.20, and MySQL Workbench.

Upvotes: 1

Views: 146

Answers (1)

Alba Mendez
Alba Mendez

Reputation: 4605

The syntax is correct,
but you had an NBSP after table.

Upvotes: 1

Related Questions