MySQL Forums :: Newbie :: Change column type?

Advanced Search

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?


Options: ReplyQuote

Subject Written By Posted
Change column type? Alberto Moreno 06/04/2009 04:19PM
Re: Change column type? Peter Brawley 06/04/2009 08:27PM
Re: Change column type? Alberto Moreno 06/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.