MySQL - DELETE

DELETE

 

 

 

 

select * from cats;

 

 

 

데이터 삭제하는 방법

delete from cats
where name = 'Egg';

 

 

 

고양이의 나이가 4살인 고양이 데이터를 삭제하세요

delete from cats
where age = 4;

 

 

 

데이터 전체 삭제

 

delete from cats;

 

 

 

 

테이블 전체삭제

 

drop table cats;