{"id":130335,"date":"2022-04-13T18:00:00","date_gmt":"2022-04-13T22:00:00","guid":{"rendered":"https:\/\/brainstation.io\/?post_type=codex-reference&p=130335"},"modified":"2025-02-04T14:40:38","modified_gmt":"2025-02-04T19:40:38","slug":"insert-into","status":"publish","type":"codex-reference","link":"https:\/\/brainstation.io\/learn\/sql\/insert-into","title":{"rendered":"Insert Into"},"content":{"rendered":"\n
<\/path><\/path><\/path><\/g><\/path><\/path><\/path><\/g><\/svg>

SQL tutorial<\/p><\/div>

SQL Insert Into<\/h1>

Learn more about SQL, a standard language for interacting with databases and storing, manipulating, and retrieving data from databases.

Go hands-on with SQL in our free interactive SQL tutorial.<\/a><\/p><\/div>

<\/div><\/div><\/div><\/header>\n\n\n\n
\n
\n

In contrast to the SELECT<\/code> statement in SQL which returns data from a table (or tables), the INSERT<\/code> statement adds records to a table. This new data can either be specified as part of the SELECT<\/code> statement itself, or be records returned from another query by combining the INSERT<\/code> statement with a SELECT<\/code> statement.<\/p>\n\n\n\n

In the former case, the INSERT<\/code> statement in SQL takes the form as below, including VALUES<\/code> and a comma-delimited list of the data to insert for each row, enclosed in parentheses:<\/p>\n\n\n\n

Code Example<\/span>