INSERT IGNORE
You are viewing an old version of this article. View
the current version here.
Ignoring errors
Normally INSERT
stops and rolls back when it encounters an error.
By using the IGNORE keyword all errors are converted to warnings, which will not stop inserts of additional rows.
Examples
How to specify the column names:
INSERT INTO person (first_name, last_name) VALUES ('John', 'Doe');
How to insert more than 1 row at a time:
INSERT INTO tbl_name VALUES (1, "row 1"), (2, "row 2");
Using the SET
clause:
INSERT INTO person SET first_name = 'John', last_name = 'Doe';
SELECTing from another table:
INSERT INTO contractor SELECT * FROM person WHERE status = 'c';
See INSERT ON DUPLICATE KEY UPDATE for further examples using that syntax.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.