Inayotaka kusoma kwa SQL SELECT INTO

Inambo ya SQL SELECT INTO inaweza kutumika kufanya kopi ya tabia.

Inambo ya SELECT INTO

Inambo ya SELECT INTO inapata data kutoka kwenye tabia moja, kisha inasaidia data kwenye tabia nyingine.

Inambo ya SELECT INTO inatumiwa kufanya kopi ya tabia ama kusafisha mawili.

Makini ya SQL SELECT INTO

Wewe unaweza kuingiza mada zote katika tablica jipya:

SELECT *
INTO new_table_name [IN externaldatabase] 
FROM old_tablename

au tuwekeze mada yalitaka katika tablica jipya:

SELECT column_name(s)
INTO new_table_name [IN externaldatabase]
FROM old_tablename

Mifano wa SQL SELECT INTO - Kufanya mafanikio

Mifano inayofanywa hapa itakufanya mafanikio wa tablica "Persons":

SELECT *
INTO Persons_backup
FROM Persons

IN kigeukia inaweza kopia tablica kwenye mpangilio wa hali ya hili:

SELECT *
INTO Persons IN 'Backup.mdb'
FROM Persons

Kama tunataka kopia mada fulani, tunaweza kumuelezea mada hayo baada ya kufikia kwa kitendo SELECT:

SELECT LastName,FirstName
INTO Persons_backup
FROM Persons

Mifano wa SQL SELECT INTO - Kina WHERE

Naweza kuongeza uamuzi WHERE.

Mifano inayofanywa hapa itakufanya tablica yenye mafomu mbili inayoitwa "Persons_backup", inayoshua habari ya watu wanaoishi huko "Beijing" kutoka tablica "Persons":

SELECT LastName,Firstname
INTO Persons_backup
FROM Persons
WHERE City='Beijing'

Mifano wa SQL SELECT INTO - Tablica inayojumuisha

Inaweza kufanya kwa habari kutoka tablica zingine zaidi.

Mifano inayofanywa hapa itakufanya tablica mpya inayoitwa "Persons_Order_Backup", inayoshua habari kutoka tablica mbili, yaani Persons na Orders:

SELECT Persons.LastName,Orders.OrderNo
INTO Persons_Order_Backup
FROM Persons
INNER JOIN Orders
ON Persons.Id_P=Orders.Id_P