insert, update, delete

- insert

insert into goodsinfo (code, title, writer, price) values ('10001', '뇌를 자극하는 Java 프로그래밍', '김윤명', 27000);

- update

update goodsinof set writer:='토마스 코멘 외 3명', price:=33600 where code = '10005';

- delete

delete from goodsinfo where code = '10005';

테이블을 삭제하는 방법

drop table goodsinfo;