MySQL - Renaming table named "TABLE 12"

Question

I'm trying to pass my problem... namely I can't rename my table named "TABLE 12" which was imported. I got a response:

#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 ''TABLE 12' TO categories' at line 1

jpossi · Accepted Answer · 2013-09-04T13:28:02.460

2

Use ` instead of ' to quote database/table/field-names in MySQL. e.g.:

RENAME TABLE `TABLE 12` TO `categories`

edited Sep 04 '13 at 13:28

answered Sep 04 '13 at 13:27

jpossi

364
2
4

score 1 · Answer 2 · answered Sep 04 '13 at 13:27

1

Use backticks on system related objects.

Assuming your table name is TABLE 12:

RENAME TABLE `TABLE 12` TO `categories`

Assuming your table name is 12:

RENAME TABLE `12` TO `categories`

Documentation

answered Sep 04 '13 at 13:27

Kermit

33,827
13
85
121

score 0 · Answer 3 · answered Sep 04 '13 at 13:29

0

Try using the backtick symbol (`) instead of quotes (').

RENAME TABLE `TABLE 12` TO `Categories`

answered Sep 04 '13 at 13:29

Tricky12

6,752
1
27
35

MySQL - Renaming table named "TABLE 12"

3 Answers3