Perintah DELETE SQL

Perintah DELETE

Perintah DELETE digunakan untuk menghapus baris dalam tabel.

Syarat

DELETE FROM tabel_nama WHERE nama_kolom = nilai

Person:

LastName FirstName Alamat Kota
Gates Bill Xuanwumen 10 Beijing
Wilson Fred Zhongshan 23 Nanjing

Hapus Baris Tertentu

"Fred Wilson" akan dihapus:

DELETE FROM Person WHERE LastName = 'Wilson'

Hasil:

LastName FirstName Alamat Kota
Gates Bill Xuanwumen 10 Beijing

Hapus Semua Baris

Bisa menghapus semua baris tanpa menghapus tabel. Ini berarti struktur, atribut dan indeks tabel tetap lengkap:

DELETE FROM table_name

atau:

DELETE * FROM table_name