swto — 2010-02-13T11:47:15-05:00 — #1
Is it possible to rename a table in a database without loosing any data?
I have a name which was OK when I first started but now it makes more sense to rename the table with a more appropriate name. Yes, it would require changing a lot in the script-- but as a hypothetical?
r937 — 2010-02-13T12:02:09-05:00 — #2
try the RENAME TABLE command
dan_grossman — 2010-02-13T12:02:49-05:00 — #3
MySQL Manual :: RENAME TABLE Syntax
The MySQL manual is good, you should check there when you have basic questions about MySQL
swto — 2010-02-13T12:10:18-05:00 — #4
I was just nervous about loosing data... but the mysql docs don't say that any data will be lost.
dan_grossman — 2010-02-13T12:21:53-05:00 — #5
You keep regular backups anyway, right?