syntax for changing column name
Posted 21 March 2006 - 12:52 PM
I need to know how to change the name of some columns in my database. I would also like to change the name of my database. All of this without altering data stored in the database or dropping anyhing. If you know the syntax to do this please let me know. Thanks.
Posted 21 March 2006 - 01:30 PM
Posted 23 March 2006 - 08:08 AM
ALTER TABLE yourTable CHANGE COLUMN yourOldColumn yourNewColumn <column details>
To rename a DB, you really need to shutdown the server, rename the actual directory itself, and then handle all the privileges. I don't think there's another way, though I think 5.1 will have a RENAME DATABASE command.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users