Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.64 KB | None | 0 0
  1. Dodanie nowego postu do tabeli POSTS.
  2. INSERT INTO POSTS (USER_ID, BODY)
  3. VALUES (1, "How You do?");
  4.  
  5. INSERT INTO POSTS (USER_ID, BODY)
  6. VALUES (2, "I'm great!");
  7.  
  8. INSERT INTO POSTS (USER_ID, BODY)
  9. VALUES (3, "Me too!");
  10.  
  11. COMMIT;
  12.  
  13. Modyfikacje w dodanym rekordzie wartość pola BODY i ustawienia jej na "To delete".
  14. UPDATE POSTS
  15. SET BODY = "To delete"
  16. WHERE ID = 7;
  17.  
  18. UPDATE POSTS
  19. SET BODY = "To delete"
  20. WHERE ID = 8;
  21.  
  22. UPDATE POSTS
  23. SET BODY = "To delete"
  24. WHERE ID = 9;
  25.  
  26. COMMIT;
  27.  
  28. Usunięcie dodany przed chwilą rekord.
  29. DELETE FROM POSTS
  30. WHERE ID = 7;
  31.  
  32. DELETE FROM POSTS
  33. WHERE ID = 8;
  34.  
  35. DELETE FROM POSTS
  36. WHERE ID = 9;
  37.  
  38. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement