John,
Saturday, May 11, 2002, 3:13:33 AM, you wrote:
JD> is there a way to delete a column from a table, without droping the whole
JD> table?
Sure, you can use ALTER TABLE:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
JD> If not is can I get sql to replicate the command to re create the
> is there a way to delete a column from a table, without droping the
> whole table?
Yep!
ALTER TABLE DROP [COLUMN] col_name
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
> If not is can I get sql to replicate the command to re create the table?
Yep!
mysqldump -qd -u
http://www.mysql.com
