BEGIN BATCH | |
INSERT INTO users (userid, password, name) VALUES ('user2', 'ch@ngem3b', 'second user'); | |
UPDATE users SET password = 'ps22dhds' WHERE userid = 'user3'; | |
INSERT INTO users (userid, password) VALUES ('user4', 'ch@ngem3c'); | |
DELETE name FROM users WHERE userid = 'user1'; | |
APPLY BATCH; |