Query SQL UPDATE and DELETE

UPDATE command is used to change the fields in a table.

Example:

Update the contents of the Produk table.

$query=”Update Produk SET namaproduk=’sower’,harga=3000,diskon=0 where kodeproduk='12345'”;

            $command=mysql_query($query);

DELETE command is used to delete a column from a table.

Example:

Deleting columns Diskon in the table Produk.

            $query=”Delete diskon from Produk where KodeProduk=’12345’”;

     $command=mysql_query($query);