Contoh Penggunaan Update di SQL

create database guru
use guru

create table teacher
(
NIP varchar(10),
Nama varchar(20),
Alamat varchar(20),
Jenis_Kelamin varchar(10),
No_Telepon varchar(15)
)

insert into teacher
    values('211','Adi','Jalan Dalung','Laki-Laki','03618686594')

insert into teacher
    values('212','Andi','Jalan Buntu','Laki-Laki','03618496792')

insert into teacher
    values('213','Nida','jalan tersesat','perempuan','03612323467')

update teacher
set Nama='Yanto'
where NIP='211'

update teacher
set nama = 'raya',
alamat = 'jl. padang luwih'
where nip = '213

select * from teacher