Data operationsMySQL
INSERT
INSERT
UPDATE
DELETE
Mutate data within transactional contexts.
Command
INSERT INTO (,) VALUES ('','');
Example usage
Add, modify, or purge rows using SQL statements.
INSERT INTO <table> (<column1>,<column2>) VALUES ('<value1>','<value2>');
UPDATE <table> SET <column> = '<value>' WHERE id = <id>;
DELETE FROM <table> WHERE created_at < NOW() - INTERVAL 30 DAY;
Related tags
Data operationsUPDATEDELETEdatabasesqlinnodb