CRUD exercises response

1. READ

1. SELECT article, color FROM shirts;
2.  
3. SELECT * FROM shirts WHERE shirt_size='M';
4.  
5. SELECT article, color, shirt_size, last_worn FROM shirts WHERE size= 'M';
6. 
   

1. //
2. UPDATE
3. 
   
4. SELECT * FROM shirts WHERE article='polo shirt';
5.  
6. UPDATE shirts SET shirt_size='L' WHERE article='polo shirt';
7.  
8. SELECT * FROM shirts WHERE article='polo shirt';
9.  
10. SELECT * FROM shirts;
11.  
12. SELECT * FROM shirts WHERE last_worn=15;
13.  
14. UPDATE shirts SET last_worn=0 WHERE last_worn=15;
15.  
16. SELECT * FROM shirts WHERE last_worn=15;
17.  
18. SELECT * FROM shirts WHERE last_worn=0;
19.  
20. SELECT * FROM shirts WHERE color='white';
21.  
22. UPDATE shirts SET color='off white', shirt_size='XS' WHERE color='white';
23.  
24. SELECT * FROM shirts WHERE color='white';
25.  
26. SELECT * FROM shirts WHERE color='off white';
27.  
28. SELECT * FROM shirts;

//

DELETE

1. SELECT * FROM shirts;
2.  
3. SELECT * FROM shirts WHERE last_worn=200;
4.  
5. DELETE FROM shirts WHERE last_worn=200;
6.  
7. SELECT * FROM shirts WHERE article='tank top';
8.  
9. DELETE FROM shirts WHERE article='tank top';
10.  
11. SELECT * FROM shirts WHERE article='tank top';
12.  
13. SELECT * FROM shirts;
14.  
15. DELETE FROM shirts;
16.  
17. SELECT * FROM shirts;
18.  
19. DROP TABLE shirts;
20.  
21. show tables;
22.  
23. DESC shirts;