Use the `INSERT INTO` statement
Insert values into all columns
`INSERT INTO table_name VALUES (value1, value2, value3);`
Insert values into specific columns
`INSERT INTO table_name (column1, column2) VALUES (value1, value2);`
Insert multiple rows
`INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4);`
Insert data from another table
`INSERT INTO table_name (column1, column2) SELECT column1, column2 FROM other_table;`
Use `DEFAULT` for default column values
`INSERT INTO table_name (column1, column2) VALUES (value1, DEFAULT);`
Use `NULL` where allowed
`INSERT INTO table_name (column1, column2) VALUES (value1, NULL);`