MySQL复制记录和复制表

创建一个原始表用来做实验；
mysql> create table user (id int primary key,name varchar(20));创建表，同时设置表的结构
mysql> desc user;查询表的结构
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | NO   | PRI | NULL    |       |
| name  | varchar(20) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
mysql> insert into user values(1,'jim'),(2,'tom'),(1000,'jack');向表里面插入内容
mysql> select * from user;查询表的内容信息
+------+------+
| id   | name |
+------+------+
|    1 | jim  |
|    2 | tom  |
| 1000 | jack |
+------+------+
3 rows in set (0.00 sec)