mysql> select * from staff;

+----+----------+-------+

| id | name     | slary |

+----+----------+-------+

|   | haofugui |  |

|   | guoming  |   |

|   | haotian  |   |

+----+----------+-------+

 rows in set (0.00 sec)

mysql> describe staff;

+-------+----------+------+-----+---------+----------------+

| Field | Type     | Null | Key | Default | Extra          |

+-------+----------+------+-----+---------+----------------+

| id    | int()  | NO   | PRI | NULL    | auto_increment |

| name  | char() | YES  |     | NULL    |                |

| slary | int()  | YES  |     | NULL    |                |

+-------+----------+------+-----+---------+----------------+

 rows in set (0.00 sec)

mysql> SELECT * INTO Persons_backup FROM Persons;

mysql> SELECT *      //跨数据库的数据复制

    -> INTO Persons IN 'Backup.mdb'

    -> FROM Persons;

mysql> SELECT LastName,FirstName

    -> INTO Persons_backup

    -> FROM Persons;

mysql> SELECT LastName,Firstname

    -> INTO Persons_backup

    -> FROM Persons

    -> WHERE City='Beijing';

mysql> SELECT Persons.LastName,Orders.OrderNo  //表连接复制，即多表复制

    -> INTO Persons_Order_Backup

    -> FROM Persons

    -> INNER JOIN Orders

    -> ON Persons.Id_P=Orders.Id_P;