修改表结构：重命名数据表,添加字段

重命名

1. ALTER TABLE tbl_name RENAME [TO/AS] new_name

mysql> ALTER TABLE user11 RENAME to user10;
Query OK, 0 rows affected (0.20 sec)

mysql> SHOW CREATE TABLE user10;
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| user10 | CREATE TABLE `user10` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` char(32) NOT NULL,
  `age` tinyint(3) unsigned DEFAULT '18',
  `addr` varchar(50) NOT NULL DEFAULT 'NY',
  `email` varchar(50) NOT NULL DEFAULT 'zhouruc16@gmail.com',
  `sex` enum('MALE','FEMALE','UNKNOWN') NOT NULL DEFAULT 'UNKNOWN',
  `salary` float(6,2) DEFAULT NULL,
  `regtime` int(10) unsigned DEFAULT NULL,
  `face` char(100) NOT NULL DEFAULT 'default.jpg',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

2. RENAME TABLE tbl_name1 to tbl_name2、

mysql> CREATE TABLE IF NOT EXISTS user10(
    -> id INT UNSIGNED KEY AUTO_INCREMENT,
    -> username VARCHAR(20) NOT NULL,
    -> password CHAR(32) NOT NULL,
    -> age TINYINT UNSIGNED DEFAULT 18,
    -> addr VARCHAR