Inserting & Loading Data

The INSERT statement is the primary SQL statement for adding data into a table in MariaDB.

Title Description
INSERT Insert rows into a table.
INSERT DELAYED Queue row to be inserted when thread is free.
INSERT SELECT Insert the rows returned by a SELECT into a table
LOAD Data into Tables or Index Loading data quickly into MariaDB
Concurrent Inserts Under some circumstances, MyISAM allows INSERTs and SELECTs to be executed concurrently.
HIGH_PRIORITY and LOW_PRIORITY Modifying statement priority in storage engines supporting table-level locks.
IGNORE Suppress errors while trying to violate a UNIQUE constraint.
INSERT - Default & Duplicate Values Default and duplicate values when inserting.
INSERT IGNORE Convert errors to warnings, permitting inserts of additional rows to continue.
INSERT ON DUPLICATE KEY UPDATE INSERT if no duplicate key is found, otherwise UPDATE
INSERT...RETURNING Returns a resultset of the inserted rows.
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.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/inserting-loading-data/