-- sql5 Test Script
-- 測試 CREATE, INSERT, SELECT, UPDATE, DELETE
CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT NOT NULL, email TEXT);
INSERT INTO users VALUES(1, 'Alice', 'alice@example.com');
INSERT INTO users VALUES(2, 'Bob', 'bob@example.com');
INSERT INTO users VALUES(3, 'Carol', 'carol@example.com');
SELECT * FROM users;
SELECT * FROM users WHERE id = 1;
SELECT * FROM users WHERE name = 'Bob';
UPDATE users SET email = 'bob_new@example.com' WHERE id = 2;
SELECT * FROM users WHERE id = 2;
DELETE FROM users WHERE id = 3;
SELECT * FROM users;
SELECT COUNT(*) FROM users;
SELECT * FROM users ORDER BY name;
SELECT 'Test completed!' AS result;