SQL DELETE buyrug‘i

DELETE buyrug‘i jadvaldagi mavjud yozuvlarni o‘chirish uchun ishlatiladi.

DELETE sintaksisi

DELETE FROM table_name WHERE condition;

Eslatma: Jadvaldagi yozuvlarni o‘chirishda juda ehtiyot bo‘ling! DELETE buyrug‘idagi WHERE shartiga e’tibor bering. WHERE sharti aynan qaysi yozuv(lar) o‘chirilishini belgilaydi. Agar WHERE shartini qoldirib ketsangiz, jadvaldagi BARCHA yozuvlar o‘chib ketadi!

Demo ma’lumotlar bazasi

Quyida misollarda foydalanilgan Customers jadvalidan tanlanma keltirilgan:

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	Alfreds Futterkiste	Maria Anders	Obere Str. 57	Berlin	12209	Germany
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución 2222	México D.F.	05021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico
4	Around the Horn	Thomas Hardy	120 Hanover Sq.	London	WA1 1DP	UK
5	Berglunds snabbköp	Christina Berglund	Berguvsvägen 8	Luleå	S-958 22	Sweden

SQL DELETE misoli

Quyidagi SQL mijoz "Alfreds Futterkiste" FROM "Customers" jadvalini o‘chirib tashlaydi:

Misol

DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';

"Customers" jadvalidan tanlanma endi quyidagicha ko‘rinadi:

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución 2222	México D.F.	05021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico
4	Around the Horn	Thomas Hardy	120 Hanover Sq.	London	WA1 1DP	UK
5	Berglunds snabbköp	Christina Berglund	Berguvsvägen 8	Luleå	S-958 22	Sweden

Barcha yozuvlarni o‘chirish

Jadvalni o‘chirmasdan undagi barcha yozuvlarni o‘chirish mumkin. Bu jadval tuzilishi, atributlari va indekslari saqlanib qolishini anglatadi.

Sintaksis

DELETE FROM table_name;

Quyidagi SQL "Customers" jadvalining o‘zini o‘chirmasdan, undagi BARCHA yozuvlarni o‘chiradi:

Misol

DELETE FROM Customers;

DELETE a Jadval

Jadvalni butunlay o‘chirish uchun DROP TABLE buyrug‘idan foydalaning:

Sintaksis

DROP TABLE table_name;

Quyidagi SQL butun "Customers" jadvalini tushiradi:

Misol

Delete entire "Customers" table:

DROP TABLE Customers;

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!

Ro'yxatdan o'tish Kirish