If working with your website's cool MySQL database looks too much like this:
Signup for your free account on ClickSQL
Telnet
mysql> show columns from address;
+--------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+----------------+
| id | int(11) | | PRI | 0 | auto_increment |
| organization | varchar(30) | | MUL | | |
| lastname | varchar(30) | | MUL | | |
| firstname | varchar(30) | | | | |
| address1 | varchar(40) | YES | | NULL | |
| address2 | varchar(40) | YES | | NULL | |
| city | varchar(20) | YES | | NULL | |
| stateprov | char(2) | | MUL | | |
| country | enum('US','Canada') | | MUL | US | |
| zip | varchar(10) | | MUL | | |
| phone | varchar(10) | | MUL | | |
| fax | varchar(10) | | | | |
| email | varchar(75) | | MUL | | |
| modified | timestamp(14) | YES | | NULL | |
| modifiedby | varchar(20) | | | | |
| created | timestamp(14) | YES | | NULL | |
| createdby | varchar(20) | | | | |
+--------------+---------------------+------+-----+---------+----------------+
17 rows in set (0.00 sec)
mysql> alter table address change id bigint;
ERROR 1064: You have an error in your SQL syntax near 'bigint' at line 1
and in just a few moments, you can make it look like
this!