SELECT INTO

SQL SELECT INTO Bayonoti

SELECT INTO bayonoti bir jadvaldan ma'lumotlarni yangi jadvalga nusxalash uchun ishlatiladi.

SELECT INTO Sintaksisi

Yangi jadvalga barcha ustunlarni nusxalash:

SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

Faqat ba'zi ustunlarni yangi jadvalga nusxalash:

SELECT column1, column2, column3, ...
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

Yangi jadval eski jadvalda belgilangan ustun nomlari va turlari bilan yaratiladi. AS bayonotidan foydalanib yangi ustun nomlarini yaratishingiz mumkin.

SQL SELECT INTO Misollari

Quyidagi SQL bayonoti Customers jadvalining zaxira nusxasini yaratadi:

SELECT * INTO CustomersBackup2017
FROM Customers;

Quyidagi SQL bayonoti IN bayonotidan foydalanib, jadvalni boshqa ma'lumotlar bazasida yangi jadvalga nusxalaydi:

SELECT * INTO CustomersBackup2017 IN 'Backup.mdb'
FROM Customers;

Quyidagi SQL bayonoti faqat bir nechta ustunlarni yangi jadvalga nusxalaydi:

SELECT CustomerName, ContactName INTO CustomersBackup2017
FROM Customers;

Quyidagi SQL bayonoti faqat Germaniya mijozlarini yangi jadvalga nusxalaydi:

SELECT * INTO CustomersGermany
FROM Customers
WHERE Country = 'Germany';

Quyidagi SQL bayonoti bir nechta jadvaldan ma'lumotlarni yangi jadvalga nusxalaydi:

SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2017
FROM Customers
LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

Maslahat: SELECT INTO bayonotidan boshqa jadvalning sxemasidan foydalanib yangi bo'sh jadval yaratish uchun ham foydalanishingiz mumkin. Faqat shuni qo'shingki, WHERE bayonoti so'rovni hech qanday ma'lumot qaytarmasligi uchun olib keladi:

SELECT * INTO newtable
FROM oldtable
WHERE 1 = 0;