2
Inserting & Loading Data
The INSERT statement is the primary SQL statement for adding data into a table in MariaDB.
-
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.
