Hello CREATE TABLE mytable_bak SELECT * FROM mytable; ALTER TABLE mytable MODIFY mycol1 VARCHAR(20)...;
Paul Maine wrote: >What SQL command can I use to change an existing column in a table with an >integer data type to a varchar data type. This is a production table with >about 3,000 records. I don't want to loose any of my current data in this >column. > > > Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH & Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de --------------------------------------------------------------------- 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
