SQL
INSERT Statement
The `INSERT` statement inserts new data into a table.  
#### Examples {#docs:sql:statements:insert::examples}  
Insert the values 1, 2, 3 into `tbl`:  
```sql
INSERT INTO tbl
VALUES (1), (2), (3);
```  
Insert the result of a query into a table:  
```sql
INSERT INTO tbl
SELECT * FROM other_tbl;
```  
Insert values into the `i` column, inserting the default value into other columns:  
```sql
INSERT INTO tbl (i)
VALUES (1), (2), (3);
```  
Explicitly insert the default value into a column:  
```sql
INSERT INTO tbl (i)
VALUES (1), (DEFAULT), (3);
```  
Assuming `tbl` has a primary key/unique constraint, do nothing on conflict:  
```sql
INSERT OR IGNORE INTO tbl (i)
VALUES (1);
```  
Or update the table with the new values instead:  
```sql
INSERT OR REPLACE INTO tbl (i)
VALUES (1);
```  
#### Syntax {#docs:sql:statements:insert::syntax}  
<div id="rrdiagram"></div>  
`INSERT INTO` inserts new rows into a table. One can insert one or more rows specified by value expressions, or zero or more rows resulting from a query.