INSERT INTO SELECT
INSERT INTO SELECT
INSERT INTO SELECT buyrug‘i ma’lumotlarni nusxalaydi
bir jadvaldan oladi va uni boshqa jadvalga kiritadi.
Quyidagi SQL "Ta’minotchilar" ni "Mijozlar" ga ko‘chiradi (ma’lumotlar bilan to‘ldirilmagan ustunlar NULLni o‘z ichiga oladi):
Misol
INSERT INTO Customers (CustomerName,
City, Country)
SELECT SupplierName, City, Country FROM Suppliers;
Quyidagi SQL "Suppliers" ni "Customers" ga nusxalaydi (barcha ustunlarni to‘ldiradi):
Misol
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode,
Country)
SELECT SupplierName, ContactName, Address, City, PostalCode,
Country FROM Suppliers;
Quyidagi SQL faqat Germaniyadagi yetkazib beruvchilarni "Customers" ga nusxalaydi:
Misol
INSERT INTO Customers (CustomerName,
City, Country)
SELECT SupplierName, City, Country FROM Suppliers
WHERE Country='Germany';
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!