SELECT INTO
SELECT INTO
SELECT INTO buyrug‘i ma’lumotlarni nusxalaydi
bitta jadvaldan va uni yangi jadvalga kiritadi.
quyidagi SQL operatori (so‘rovi) mijozlarning zaxira nusxasini yaratadi:
SELECT * INTO CustomersBackup2017
FROM Customers;Quyidagi SQL iborasi jadvalni boshqa ma’lumotlar bazasidagi yangi jadvalga nusxalash uchun IN bandidan foydalanadi:
SELECT *
INTO CustomersBackup2017 IN 'Backup.mdb'
FROM Customers;Quyidagi SQL buyrug‘i faqat bir nechta ustunni yangi jadvalga nusxalaydi:
SELECT CustomerName, ContactName INTO CustomersBackup2017
FROM Customers;Quyidagi SQL buyrug‘i faqat Germaniyadagi mijozlarni yangi jadvalga nusxalaydi:
SELECT *
INTO CustomersGermany
FROM Customers
WHERE Country = 'Germany';quyidagi SQL operatori (so‘rovi) bir nechta jadvaldagi ma’lumotlarni yangi jadvalga ko‘chiradi:
SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2017
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!