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/