/*创建的表t1开始：
mysql> CREATE TABLE t1 (a INTEGER,b CHAR(10));
重命名表，从t1到t2:
mysql> ALTER TABLE t1 RENAME t2;
为了改变列a，从INTEGER改为TINYINT NOT NULL(名字一样)，并且改变列b，

从CHAR(10)改为CHAR(20)，同时重命名它，从b改为c：
mysql> ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
增加一个新TIMESTAMP列，名为d：
mysql> ALTER TABLE t2 ADD d TIMESTAMP;
在列d上增加一个索引，并且使列a为主键：
mysql> ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a);
删除列c：
mysql> ALTER TABLE t2 DROP COLUMN c;
增加一个新的AUTO_INCREMENT整数列，命名为c：
mysql> ALTER TABLE t2 ADD c INT UNSIGNED NOT NULL AUTO_INCREMENT,
      ADD INDEX (c);*/

root@host# mysql -u root -p password;
Enter password:*******
mysql> use TUTORIALS;
Database changed
mysql> create table testalter_tbl
  -> (
  -> i INT,
  -> c CHAR(1)
  -> );
Query OK, 0 rows affected (0.05 sec)
mysql> SHOW COLUMNS FROM testalter_tbl;
+-------+---------+------+-----+---------+-------+
| Field | Type  | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| i   | int(11) | YES |   | NULL  |    |
| c   | char(1) | YES |   | NULL  |    |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> SHOW COLUMNS FROM testalter_tbl;
+-------+---------+------+-----+---------+-------+
| Field | Type  | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| c   | char(1) | YES |   | NULL  |    |
| i   | int(11) | YES |   | NULL  |    |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)

ALTER TABLE testalter_tbl DROP i;
ALTER TABLE testalter_tbl ADD i INT FIRST;
ALTER TABLE testalter_tbl DROP i;
ALTER TABLE testalter_tbl ADD i INT AFTER c;

mysql> ALTER TABLE testalter_tbl CHANGE i j BIGINT;
mysql> ALTER TABLE testalter_tbl CHANGE j j INT;

mysql> ALTER TABLE testalter_tbl
  -> MODIFY j BIGINT NOT NULL DEFAULT 100;

mysql> ALTER TABLE testalter_tbl ALTER i SET DEFAULT 1000;
mysql> SHOW COLUMNS FROM testalter_tbl;
+-------+---------+------+-----+---------+-------+
| Field | Type  | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| c   | char(1) | YES |   | NULL  |    |
| i   | int(11) | YES |   | 1000  |    |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> ALTER TABLE testalter_tbl ALTER i DROP DEFAULT;
mysql> SHOW COLUMNS FROM testalter_tbl;
+-------+---------+------+-----+---------+-------+
| Field | Type  | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| c   | char(1) | YES |   | NULL  |    |
| i   | int(11) | YES |   | NULL  |    |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
Changing a Table Type:

 mysql> ALTER TABLE testalter_tbl TYPE = MYISAM;
mysql> SHOW TABLE STATUS LIKE 'testalter_tbl'\G
*************************** 1. row ****************
      Name: testalter_tbl
      Type: MyISAM
   Row_format: Fixed
      Rows: 0
 Avg_row_length: 0
  Data_length: 0
Max_data_length: 25769803775
  Index_length: 1024
   Data_free: 0
 Auto_increment: NULL
  Create_time: 2007-06-03 08:04:36
  Update_time: 2007-06-03 08:04:36
   Check_time: NULL
 Create_options:
    Comment:
1 row in set (0.00 sec)