Wednesday, February 12, 2020

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';

  1. //
  2. UPDATE

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

No comments:

Post a Comment

Right Joins

-- OUR FIRST RIGHT JOIN (seems the same as a left join?) SELECT * FROM customers RIGHT JOIN orders     ON customers.id = orders.custom...