I need to alter this table to change the data type of field phone from int to bigint in Mysql.

what would be the command to do so.

figured it out myself as

alter table customer change row phone int to bigint;

| Null | Key| Default | Extra int (11) varchar (30) NO varchar (40) NO varchar(50) | NO varchar (50) NO char (2) int (11) int (11) NO | PRI | NULL auto_increment first_name ast name st reet state zIp phone email address varchar (50) NO YES 0 0 0