stilts77 stilts77 - 4 months ago 10
SQL Question

I can't rename a mysql table name... it has a space in it

I've imported a csv into MySQL. PHPMyAdmin helpfully created a table called TABLE 8 (with a space).

When I try to rename in SQL:

RENAME TABLE 8 to gender


I get the error:

#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 8` to `gender`' at line 1


I have tried back-ticks, quotes... seemingly everything...

I guess it's the space that's causing the problem but I'm out of ideas.

Answer

The syntax is wrong, you're missing the table keyword (and yes, note the `s to escape the table name containing a space):

RENAME TABLE `TABLE 8` TO gender

Alternatively, you could use the fuller syntax:

ALTER TABLE `TABLE 8` RENAME TO gender
Comments