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, "This is my first post on this forum!");
- INSERT INTO POSTS (USER_ID, BODY)
- VALUES (1, "This is my first post on this forum!");
- INSERT INTO POSTS (USER_ID, BODY)
- VALUES (1, "This is my first post on this forum!");
- COMMIT;
- Modyfikacje w dodanym rekordzie wartość pola BODY i ustawienia jej na "To delete".
- UPDATE POSTS
- SET BODY = "To delete"
- WHERE ID = 14;
- UPDATE POSTS
- SET BODY = "To delete"
- WHERE ID = 15;
- UPDATE POSTS
- SET BODY = "To delete"
- WHERE ID = 16;
- COMMIT;
- Usunięcie dodany przed chwilą rekord.
- DELETE FROM POSTS
- WHERE ID = 14;
- DELETE FROM POSTS
- WHERE ID = 15;
- DELETE FROM POSTS
- WHERE ID = 16;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement