Write records
Insert, update and delete application records.
Example
Section titled “Example”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;Behavior
Section titled “Behavior”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.
Related
Section titled “Related”This site uses Google Analytics cookies to count visits. Privacy · License