mysql> desc test;
+
| Field | Type | Null | Key | Default | Extra |
+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | YES | | NULL | |
| sex | varchar(1) | YES | | NULL | |
| age | tinyint(3) unsigned | YES | | NULL | |
+
mysql> desc user;
+
| Field | Type | Null | Key | Default | Extra |
+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | YES | | NULL | |
| age | tinyint(3) unsigned | YES | | NULL | |
+
mysql> select * from test;
+
| id | name | sex | age |
+
| 1 | name1 | 男 | 5 |
| 2 | name2 | 女 | 10 |
| 3 | name3 | 男 | 15 |
| 4 | name4 | 男 | 20 |
+
mysql> select * from user;
Empty set (0.00 sec)
mysql> insert into user (name, age) select name, age from test;
Query OK, 4 rows affected (0.00 sec)
mysql> select * from user;
+
| id | name | age |
+
| 1 | name1 | 5 |
| 2 | name2 | 10 |
| 3 | name3 | 15 |
| 4 | name4 | 20 |
+
