CRUD — Exemples complets

essentiel

CREATE TABLE etudiants (
  id INTEGER PRIMARY KEY,
  nom TEXT NOT NULL,
  age INTEGER
);

-- Create
INSERT INTO etudiants (nom, age) VALUES ('Alice', 20);

-- Read
SELECT * FROM etudiants WHERE age >= 18;

-- Update
UPDATE etudiants SET age = age + 1 WHERE nom = 'Alice';

-- Delete
DELETE FROM etudiants WHERE id = 1;

Upsert

INSERT INTO etudiants (id, nom, age) VALUES (1, 'Alice', 21)
ON CONFLICT(id) DO UPDATE SET age = excluded.age;

Pagination

SELECT * FROM etudiants ORDER BY id LIMIT 20 OFFSET 40;