SQLite

• Official Website
• Not Implemented SQL Features
• Frequently Asked Questions

Create

CREATE TABLE user (
    id INTEGER NOT NULL,
    name TEXT,
    CONSTRAINT 'user_pk_id' PRIMARY KEY (id),
    CONSTRAINT 'user_uq_id' UNIQUE (id)
);

CREATE INDEX user_ind_name
ON user (name);

Read

SELECT * FROM user;

SELECT name
FROM user
WHERE id == 1;

SELECT count(*) AS user_count
FROM user;

Update

INSERT INTO user (id, name)
VALUES
    (1, 'First'),
    (2, 'Second');

UPDATE user
SET name = 'Saplyn'
WHERE id == 1;

ALTER TABLE user
ADD COLUMN email TEXT;

Delete

DELETE FROM user
WHERE name = 'Saplyn';

DROP TABLE user;