HomeОбразованиеRelated VideosMore From: The Bad Tutorials

SQL Tutorial - 12: Inserting Data Into Tables

425 ratings | 141934 views
In this tutorial we'll learn to insert data into tables using the INSERT INTO statement.
Html code for embedding videos on your blog
Text Comments (32)
Amit Agarwal (26 days ago)
This is worst way of using INSERT statement in SQL Better way is as follow Insert into tablename set col1=val1, col2=val2, col3=val3; This insert is like update statement and it works 100% fine
Kalyan Tarafdar (2 months ago)
please help me to download the version of sql database you are using please
_ _ (4 months ago)
tanks
Creative Sham (4 months ago)
i am facing an issue there is no error but data is not inserting.. that only happens if i use id as autoincriment. how can i fix this
nice explan
thanks my dear
Brandon Huitt (5 months ago)
i have a database class and the professor i have online sucks and dont teach anything now videos or anything.. is it possible to write the script on word and then copy and paste it into the sql
Afalaa (6 months ago)
Excellent tutorial. Liked it and subscribe to your channel.
chaitanya reddy (6 months ago)
y are u using semi-colon for date-time datatype .may i know sir?
Kanishka Gupta (8 months ago)
what data type is to be used is email id also contain numbers with characters..
Mateusz Leśko (7 months ago)
id = int, email = varchar
Jonathan Cook (9 months ago)
What is the problem when you try to use the DESC command and it says cannot find stored procedure?
Top5Category (11 months ago)
How can we insert multiple values in table??
chaitanya reddy (6 months ago)
we should use insert query as many times we want to insert data
Top5Category (11 months ago)
Awesome tutorial !!
Ravi Mahtele (1 year ago)
Sir how can we insert multiple records by typing values of all fields, like Name Class Mob.No Ram 12th 999999 Shyam 10th 100000
Nicholas Baker (1 year ago)
exactly like you just did but with proper syntax: insert into table_name (name, class, mob.no) values('ram', '12th', 999999) ,('shayam', '10th', 100000);
dhruw lalan (1 year ago)
legends are born in November!!
shankar lingam (1 year ago)
One of the best sql tutorial bro thank you so much its very useful for me because i am from non-it branch ....continue we expect more videos about several programming languague like dot net....
jitendra gupta (1 year ago)
Hi, How can I download MySQL Workbench?
suraj ahlawat (1 year ago)
Can you please tell me why the "name" column is blue but other columns like id , dob are not blue in 12 tutorial?????
Samuel Herlander (1 year ago)
HAPPY BDAY ! :D
Walz Walz (1 year ago)
What the hell just happened 😂😂😂😂
부리부리자이몽 (1 year ago)
I've searching youtube vid since having trouble with SQL... and could not find proposed solution for creating table and populate them,... but i assure this is the one of best vid ever! helped me a lot Great teacher!!
Jane E (2 years ago)
I have tried but I get "incorrect sytax near the keyword". And do you have any idea how to insert a second row, third row etc.?
Santosh Paudel (2 years ago)
Thanks man! You're a great teacher
Narendra Thakkar (2 years ago)
Happy Birthday
mrmendabest (2 years ago)
happy birthday in 3 days :)
McGavel1 (3 years ago)
Awesome, thanks!
MAHAK JAIN (3 years ago)
hello.. suppose there are 10 columns into table and we insert values only into 8 fields thn error will generate.? insert into employee (1, 2 , 33, 33 ); this is done and there are 10 colmns in table employee thn error vl come or nt
Vishal Singh Rajput (3 years ago)
Hey Madhur tomorrow ur having ur Birthday ;)
mxd slx (4 years ago)
yes i like it

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.