Insert & Query

Code

-- 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;

Explanation

Always use parameterized queries (?) to prevent SQL injection; SQLite's C API and most drivers support them natively. Wrapping bulk inserts in a transaction dramatically improves performance by committing once instead of per statement. LIKE patterns use % as a wildcard for substring matching.

More SQLite Snippets