> 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> <tablename> http://www.mysql.com/doc/m/y/mysqldump.html > can I transfer information to a dummy table while > I create the table I want? Yep! Just do a select into outfile http://www.mysql.com/doc/S/E/SELECT.html then a load data infile http://www.mysql.com/doc/L/O/LOAD_DATA.html Take care, seth --------------------------------------------------------------------- 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
