INSERT INTO
INSERT INTO
INSERT INTO buyrug‘i jadvalga yangi qatorlar kiritish uchun ishlatiladi.
Quyidagi SQL kodi Customers jadvaliga yangi yozuv kiritadi:
Misol
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');
Quyidagi SQL yangi yozuvni kiritadi, lekin faqat "Mijoz nomi", "Shahar" va "Mamlakat" ustunlariga ma’lumotlarni kiritadi (CustomerID avtomatik ravishda yangilanadi):
Misol
INSERT INTO Customers (CustomerName, City, Country)
VALUES ('Cardinal', 'Stavanger', 'Norway');
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!