select

UK[s??lekt] US[s??l?kt]

vt.Select; select; select

adj. Selected; select out; selective; picky, picky

Third person singular: selects Present participle: selecting Past tense: selected Past participle: selected

into

UK[??nt?] US[??ntu]

prep. (Indicates direction) enters...; (indicates belonging) input; (indicates status) enters... state; ( indicates time) lasts until

mysql SELECT INTO statement syntax

Function: Used to create a backup copy of the table.

Syntax: SELECT * INTO new_table_name [IN externaldatabase] FROM old_tablename

Description: SELECT INTO statement selects data from a table, and then Data is inserted into another table. The SELECT INTO statement is often used to create a backup copy of a table or to archive records.

mysql SELECT INTO statement example

//制作 "Persons" 表的備份復(fù)件
SELECT * INTO Persons_backup FROM Persons;
//通過從 "Persons" 表中提取居住在 "Beijing" 的人的信息，創(chuàng)建了一個帶有兩個列的名為 "Persons_backup" 的表
SELECT LastName,FirstnameINTO Persons_backup FROM Persons WHERE City='Beijing';
//創(chuàng)建一個名為 "Persons_Order_Backup" 的新表，其中包含從 Persons 和 Orders 兩個表中取得的信息
SELECT Persons.LastName,Orders.OrderNoINTO Persons_Order_Backup FROM Persons INNER JOIN OrdersON Persons.Id_P=Orders.Id_P;