How to insert multiple records In a SQL Table using single insert statement

preview_player
Показать описание
The INSERT INTO statement is used to add new data to a table. INSERT INTO adds a new record to a table. INSERT INTO can contain values for some or all of its columns. INSERT INTO can be combined with a SELECT to insert records
The INSERT INTO statement is used to add new data to a table.
INSERT INTO adds a new record to a table.
INSERT INTO can contain values for some or all of its columns.
INSERT INTO can be combined with a SELECT to insert records.

In this video we have covered.

What is SQL insert into statement?
How to write query for inserting data into SQL table
It is possible to write the INSERT INTO statement in two ways.
1) The first way specifies both the column names and the values to be inserted:
2) the second way is that you do not need to specify the column names in the SQL query if you are adding values for all the columns of the table

__________________________________________________________________________________________________

You can follow us on the below social media handles:-
Рекомендации по теме
Комментарии
Автор

I've got what I've been searching for thanks for that. But the video could be mire concise and straight to the point.

ebinesh.a
Автор

Very Helpful, continue sharing your great work

ilupeter
Автор

Thanks you so much for posting, it help me a lot in my learning.

mangkhongsai
Автор

Thankyou so much. It was really very helpful

nikithatrivedi
Автор

Thank you so much for posting this. Do you know if there's a way to insert a value through a certain range?
Example:
Insert Into PortalDocumentOptions
(portalID, moduleID, form)
Values
(13, 16, 1),
(14, 16, 1),
(15, 16, 1)
... If I wanted to go all the way to (126, 16, 1)?

carrjar
Автор

Bro... Please give me command for insertion with ambersent (&) at run time insertion nog data ....

hemanthkumarv
Автор

What if i have to insert 100 rows of data. Then i cannot use this method because it will be very long...

anirudhcool
Автор

On which software you use in this video

jatingupta
Автор

whenever i do this on command line it always says error at line 2, why?

shahriarrafsun
Автор

Hi i know i am late for this but please what if the query still don't work even after that because mine still says column count doesn't match value count at row 4

gadhardstone
Автор

but how to add value in the 5th row marks?

madhu.
Автор

I swear my syntax is right but somehow its not working for oracle SQL

kennethkath
Автор

sorry, multiple insert rows
query is not

sachinkadam
Автор

Wah bro simple thumbnail m likh dete just copy paste .

shazern
Автор

You have skipped how to insert marks only for student 5 please write the command for it. Thank you.

satishkumar-oizk
Автор

is vdo ko anubhav singh bassi k sath vale ko dikhao

mayankdhiman
Автор

what was new in this? Say - just do copy and paste.

satviksatvik