rename table with "-" in it

[max1x]

A user created a table my-data, how can I rename it to mydata.

 

[johnwm]

http://dev.mysql.com/doc/refman/5.0/en/rename-table.html

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[max1x]

johnwm:
I don't know if missed something in that article, which I had looked at prior as well, but it does not state how to replace a table name with "-" in it. So the currnet table name is "my-data" and using
rename table my-data to mydata, errors out;
I've also tried

rename table "my-data" to mydata;
rename table 'my-data" to mydata;

but nothing seems to work

 

[johnwm]

Sorry - missed the hyphen! Just open MySQL Query Browser (

http://dev.mysql.com/downloads/gui-tools/5.0.html),

right-click on the 'my-data' table name and select Edit Table. You can change the name there directly.

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[r937]

RENAME TABLE `my-data` TO mydata;

notice backticks, not quotes



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon