Check out the alter table syntax ... something to note you can't just change the name - you have to retype the whole column signature:
ALTER TABLE [table] CHANGE [old column name] [new column name] [old column definition]; ie. ALTER TABLE users CHANGE st state char(2) NOT NULL DEFAULT 'MI'; --Joe -- Joe Stump <[EMAIL PROTECTED]> http://www.joestump.net -----Original Message----- From: Gianluca Carnabuci [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 8:30 AM To: [EMAIL PROTECTED] Subject: column name Hi all, I guess it's a dumb question for you guys, but MySql manual doesn't seem to offer newbies a great deal of help on this one: how do I change a column name? Gian --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php