SQL Insert Into a Database Table (How To with Examples)

preview_player
Показать описание

The SQL INSERT command allows you to add or insert data into a table. It's a common command and one of the first commands you learn when you start to learn SQL.

It's part of the SQL standard, which means it can be run on any database that supports SQL, such as Oracle, SQL Server, MySQL, and PostgreSQL.

I demonstrate this with an example in this video, step-by-step.

You can also insert multiple rows with a single statement, and insert the results of a select query. I cover those briefly in this video as well.

Timestamps:
00:00 Start
00:20 What the Insert statement does
00:38 Insert statement syntax
01:45 Optional column names
02:12 Values clause
03:31 Run the statement
03:50 Multiple rows at once
04:48 Insert from Select
Рекомендации по теме