Pernyataan DELETE FROM digunakan menghapus records dari tabel database.
pernulisan
DELETE FROM nama_table WHERE column_name = nilai |
Contoh
tabel “Person”.
| FirstName | LastName | Age |
|---|---|---|
| Peter | Griffin | 35 |
| Glenn | Quagmire | 33 |
Contoh berikut menghapus records dalam tabel “Person” dimana LastName=’Griffin’:
<?php $con = mysql_connect("localhost","peter","abc123");
if (!$con) { die('Could not connect: ' . mysql_error()); }
mysql_select_db("my_db", $con);
mysql_query("DELETE FROM Person WHERE LastName='Griffin'");
mysql_close($con); ?> |
Setelah dijalankan, akan terlihat seperti ini
| FirstName | LastName | Age |
|---|---|---|
| Glenn | Quagmire | 33 |
DIarsipkan di bawah: Database, PHP, Pemrograman, mySQL
