Skip to content
Data operationsMySQL

INSERT

INSERTUPDATEDELETE

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