mysql表的其它操作

表中增加列：
mysql> ALTER TABLE test ADD age tinyint(2) DEFAULT 0;
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> ALTER table test CHANGE age age tinyint(2) NOT NULL DEFAULT 0;
Query OK, 5 rows affected (0.03 sec)
Records: 5 Duplicates: 0 Warnings: 0

更改表名：
mysql> show tables;
+——————-+
| Tables_in_oldboys |
+——————-+
| student |
| test |
+——————-+
2 rows in set (0.00 sec)

mysql> RENAME TABLE test TO test1;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+——————-+
| Tables_in_oldboys |
+——————-+
| student |
| test1 |
+——————-+
2 rows in set (0.00 sec)
mysql> ALTER TABLE test1 RENAME to test;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+——————-+
| Tables_in_oldboys |
+——————-+
| student |
| test |
+——————-+
2 rows in set (0.00 sec)