MySQL Forums
Forum List  »  Newbie

Change column type?
Posted by: Alberto Moreno
Date: June 04, 2009 04:19PM

Hi people.

I use phpMyAdmin to access and manage my mysql 5.0.x server. I have some tables that have different value type, example:

Table #1
CargaID bigint(20) unsigned NO PRI NULL auto_increment

Table #2
CargaID int(11) NO PRI NULL

Table #3
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?

Thanks!!!

Options: ReplyQuote


Subject
Written By
Posted
Change column type?
June 04, 2009 04:19PM
June 04, 2009 08:27PM
June 05, 2009 03:39PM


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.