Change column type?
Posted by: Alberto Moreno
Date: June 04, 2009 04:19PM
I use phpMyAdmin to access and manage my mysql 5.0.x server. I have some tables that have different value type, example:
CargaID bigint(20) unsigned NO PRI NULL auto_increment
CargaID int(11) NO PRI NULL
CargaID int(10) unsigned NO MUL NULL
This is the key between this tables, I would like to change this column in all the tables to:
CargaID int(20) unsigned
To make this possible, can I just pickup the value with phpMyAdmin and change it? Or exist other way to do this? Could I lost or corrupt my data?
Can I just change from bigint to int or vice versa?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.