Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dodanie nowego postu do tabeli POSTS.
- INSERT INTO POSTS (USER_ID, BODY)
- VALUES (1, "How You do?");
- INSERT INTO POSTS (USER_ID, BODY)
- VALUES (2, "I'm great!");
- INSERT INTO POSTS (USER_ID, BODY)
- VALUES (3, "Me too!");
- COMMIT;
- Modyfikacje w dodanym rekordzie wartość pola BODY i ustawienia jej na "To delete".
- UPDATE POSTS
- SET BODY = "To delete"
- WHERE ID = 7;
- UPDATE POSTS
- SET BODY = "To delete"
- WHERE ID = 8;
- UPDATE POSTS
- SET BODY = "To delete"
- WHERE ID = 9;
- COMMIT;
- Usunięcie dodany przed chwilą rekord.
- DELETE FROM POSTS
- WHERE ID = 7;
- DELETE FROM POSTS
- WHERE ID = 8;
- DELETE FROM POSTS
- WHERE ID = 9;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement