mysql 複製表結構 / 從結果中匯入資料到新表

標籤：like   複製表   ica   div   default   root   rom   複製   localhost   

這隻會複製結構:

mysql> create table a like mysql1;Query OK, 0 rows affected (0.03 sec)mysql> desc a;+----------+----------+------+-----+---------+-------+| Field    | Type     | Null | Key | Default | Extra |+----------+----------+------+-----+---------+-------+| user     | char(80) | NO   |     |         |       || host     | char(60) | NO   |     |         |       || password | char(41) | NO   |     |         |       |+----------+----------+------+-----+---------+-------+3 rows in set (0.00 sec)mysql> select * from a;Empty set (0.00 sec)mysql>

 

這除了複製結構， 還會複製結果集：

mysql> create table t8 select user,host from mysql.user;Query OK, 1 row affected (0.03 sec)Records: 1  Duplicates: 0  Warnings: 0mysql> desc t8;+-------+----------+------+-----+---------+-------+| Field | Type     | Null | Key | Default | Extra |+-------+----------+------+-----+---------+-------+| user  | char(80) | NO   |     |         |       || host  | char(60) | NO   |     |         |       |+-------+----------+------+-----+---------+-------+2 rows in set (0.01 sec)mysql> select * from t8;+------+-----------+| user | host      |+------+-----------+| root | localhost |+------+-----------+1 row in set (0.00 sec)mysql>

 

mysql 複製表結構 / 從結果中匯入資料到新表