Code
sqlite
-- Insert with parameterized placeholders (driver-specific)
INSERT INTO users (username, email) VALUES (?, ?);
-- Bulk insert via transaction
BEGIN;
INSERT INTO users (username, email) VALUES ('alice', '[email protected]');
INSERT INTO users (username, email) VALUES ('bob', '[email protected]');
INSERT INTO users (username, email) VALUES ('carol', '[email protected]');
COMMIT;
-- Query with limit and ordering
SELECT id, username, created FROM users
ORDER BY created DESC LIMIT 10;
-- Search and aggregate
SELECT username FROM users WHERE email LIKE '%@example.com';
SELECT COUNT(*) AS total, MAX(created) AS latest FROM users;
-- Update and delete
UPDATE users SET email = '[email protected]' WHERE id = 1;
DELETE FROM users WHERE id = 1;