Sintak Dasar
Di bawah ini adalah sintak dasar Delete statement di MySQL:
DELETE FROM table_name WHERE [condition];
Untuk menghapus semua data yang terdapat dalam sebuah table, Anda dapat menghilangkan Where clause pada sintak Delete statement diatas.
Contoh
Misalkan Anda telah memiliki sebuah table dengan nama "TBL_PEGAWAI" dengan data-data sebagai berikut:
mysql> SELECT * FROM tbl_pegawai; +------------+------------------+---------------+----------+------------+------------+ | id_pegawai | nama_pegawai | jenis_kelamin | gaji | alamat | departemen | +------------+------------------+---------------+----------+------------+------------+ | 1 | Nursalim | L | 1000000 | Brebes | IT | | 2 | Naura Krasiva | P | 1500000 | Tegal | FIN | | 3 | Nurul Anawariyah | P | 2000000 | Pemalang | HRD | | 4 | Achmad Fathoni | L | 3000000 | Batang | IT | | 5 | Nurul Hikmah | P | 9000000 | Pekalongan | DIR | | 6 | Iskiyati | P | 3000000 | Semarang | ACC | | 7 | Dodi Al Farizi | L | 3000000 | Kendal | FIN | | 8 | Susanto | L | 4500000 | Cilacap | MKT | | 9 | Susanti | P | 43500000 | Banyumas | MKT | | 10 | Doni Nugroho | L | 3750000 | Pemalang | HRD | +------------+------------------+---------------+----------+------------+------------+ 10 rows in set (0.07 sec)Dari data pegawai diatas,
- Delete data pegawai yang mempunyai id_pegawai = 4, dan tampilkan kembali data pegawai
mysql> DELETE FROM tbl_pegawai -> WHERE id_pegawai = 4; Query OK, 1 row affected (0.08 sec)
mysql> SELECT * FROM tbl_pegawai; +------------+------------------+---------------+----------+------------+------------+ | id_pegawai | nama_pegawai | jenis_kelamin | gaji | alamat | departemen | +------------+------------------+---------------+----------+------------+------------+ | 1 | Nursalim | L | 1000000 | Brebes | IT | | 2 | Naura Krasiva | P | 1500000 | Tegal | FIN | | 3 | Nurul Anawariyah | P | 2000000 | Pemalang | HRD | | 5 | Nurul Hikmah | P | 9000000 | Pekalongan | DIR | | 6 | Iskiyati | P | 3000000 | Semarang | ACC | | 7 | Dodi Al Farizi | L | 3000000 | Kendal | FIN | | 8 | Susanto | L | 4500000 | Cilacap | MKT | | 9 | Susanti | P | 43500000 | Banyumas | MKT | | 10 | Doni Nugroho | L | 3750000 | Pemalang | HRD | +------------+------------------+---------------+----------+------------+------------+ 9 rows in set (0.00 sec)
- Delete data pegawai yang mempunyai jenis kelamin laki-laki, dan tampilkan kembali data pegawai.
mysql> DELETE FROM tbl_pegawai -> WHERE jenis_kelamin = 'L'; Query OK, 4 rows affected (0.06 sec)
mysql> SELECT * FROM tbl_pegawai; +------------+------------------+---------------+----------+------------+------------+ | id_pegawai | nama_pegawai | jenis_kelamin | gaji | alamat | departemen | +------------+------------------+---------------+----------+------------+------------+ | 2 | Naura Krasiva | P | 1500000 | Tegal | FIN | | 3 | Nurul Anawariyah | P | 2000000 | Pemalang | HRD | | 5 | Nurul Hikmah | P | 9000000 | Pekalongan | DIR | | 6 | Iskiyati | P | 3000000 | Semarang | ACC | | 9 | Susanti | P | 43500000 | Banyumas | MKT | +------------+------------------+---------------+----------+------------+------------+ 5 rows in set (0.00 sec)
- Delete semua data pegawai, dan tampilkan kembali data pegawai.
mysql> DELETE FROM tbl_pegawai; Query OK, 5 rows affected (0.09 sec)
mysql> SELECT * FROM tbl_pegawai; Empty set (0.00 sec)
Salam,
Nursalim
No comments:
Post a Comment