How to used UPDATE Statement

The UPDATE Statement, first begins with making table will be updated later in which field update.

The UPDATE Format :

UPDATE <TABEL_NAME> 
SET 
<FIELDNAME>=<DATA_FIELD> 
WHERE 
<FIELDWHERE>=<ROWWHERE>;

The UPDATE Example :

UPDATE MAHASISWA 
SET ALAMAT='JL. JEPUN PIPIL NO 56, BR PERANG LUKLUK' 
WHERE ID_MHS=1;

 

Leave a Comment.