# INSERT INTO
## Definition(s)
### Context
#### Sub-context
>[! Definition]
>A method of updating a database with new values.
## Examples
### Adding data to a destination from another source
```SQL
INSERT INTO
[destination_table_name]
SELECT
[column names, separated by commas, or * for all columns]
FROM
[source_table_name]
WHERE
[condition]
```
#### Example _Import_ from source to target
```SQL
INSERT INTO
customer_promotion --Destination table
SELECT
* --Source field selections
FROM
customers --Source table
WHERE
total_sales = 0 -- source ex. condition 1
AND postal_code = '12345' -- source ex. condition 2
```
### Basic Insertion
```SQL
INSERT INTO project.db.table
(customer_id, name, address, city, state, zipcode, country)
VALUES
(2645, 'Rachel diSantos', '333 n. 33rd ave.', 'Jackson', 'MI', 53096, 'usa')
```
## Related
[[SQL keywords]]
## Resources
## Flashcards
The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/)