MySQL - CRUD 실습 문제 풀이

이 글 이전에 포스팅한 CRUD로 실습 문제풀이를 하는 과정입니다.

 

1.

2.

select article,color
from shirts;

3.

select article,color,shirt_size,last_worn
from shirts
where shirt_size='M';

4.

update shirts
set shirt_size = 'L'
where article = 'polo shirt';

5.

update shirts
set last_worn = 0
where last_worn > 15;

6.

update shirts
set shirt_size = 'XS' , color = 'off white'
where color = 'white';

7.

delete from shirts
where last_worn > 200;

8.

delete from shirts
where article = 'tank top';

9.

delete from shirts;

10.

drop table shirts;