UPDATE, DELETE

update

update test6
set Lname = '병만'
where Fname = 'Kim';
--select * from  test6 where Fname = 'Kim';

 

delete

--DELETE
delete from test6 where Fname = 'Kim';
--select* from test6 where Fname='Kim';