Can I change the data type of a column in a table from varchar(10) to smallint(5) unsigned zerofill. The column that is set to varchar(10) is populated with values from a primary key column in another table that has a datatype smallint(5) unsigned zerofill and I need to make them both the same. I administer my MySQL database from the command line and just need to know the syntax for changing data types. Also, can I do this without affecting the data that is currently in the varchar(10) column (this data has came from a column of the data type that I wish to change to)?
**************************************************** This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no further ation based upon the content of the message. Internet e-mails are not necessarily secure and CCM Limited does not accept any responsibility for changes made to this message. Although checks have been made to ensure this message and any attchments are free from viruses the recipient should ensure that this is the case. **************************************************** --------------------------------------------------------------------- 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
