Skip to content
ParticleDB
Release candidateParticleDB 1.1.19-rc.17 is not yet GA or ready for production data.Release status →

Write records

Insert, update and delete application records.

CREATE TABLE docs_write (id BIGINT PRIMARY KEY, title TEXT, status TEXT);
INSERT INTO docs_write VALUES (1, 'Review', 'pending'), (2, 'Reply', 'pending');
UPDATE docs_write SET status = 'completed' WHERE id = 1;
DELETE FROM docs_write WHERE id = 2;
SELECT id, status FROM docs_write ORDER BY id;

Record 1 remains with status completed. Always check the affected-row count. An omitted WHERE can change every record. Use a transaction when multiple writes form one application operation.

SQL reference · Application guide · Troubleshooting