I have a table that has a column : session_id INTEGER UNSIGNED NOT NULL, I now want to store a hexadecimal value in this column instead.
the column already contains values for some records.....can I alter the data type of this column (make it a varchar) without loosing the data already stored? or must I drop the column and then add it using the new data type. I would loose my data by dropping the column. (I can extract the data and repopulate the table (with the new data type field) if necessary but would like to avoid this) any ideas? Regards Joe
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]