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?
If not is can I get sql to replicate the command to re create the table?
and if I can't do that how can I transfer information to a dummy table while
I create the table I want?
PS, I only have command line access
is there a way to delete a column from a table, without droping the
whole table?
Yep!
ALTER TABLE tablename 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 user database