In this tutorial we’ll learn to insert data into tables using the INSERT INTO statement.
Original source
SQL Tutorial – 12: Inserting Data Into Tables
In this tutorial we’ll learn to insert data into tables using the INSERT INTO statement.
Original source
23 responses to “SQL Tutorial – 12: Inserting Data Into Tables”
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
please help me to download the version of sql database you are using please
tanks
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
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
Excellent tutorial.
Liked it and subscribe to your channel.
y are u using semi-colon for date-time datatype .may i know sir?
what data type is to be used is email id also contain numbers with characters..
What is the problem when you try to use the DESC command and it says cannot find stored procedure?
How can we insert multiple values in table??
Awesome tutorial !!
Sir how can we insert multiple records by typing values of all fields, like
Name Class Mob.No
Ram 12th 999999
Shyam 10th 100000
legends are born in November!!
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….
Hi, How can I download MySQL Workbench?
Can you please tell me why the "name" column is blue but other columns like id , dob are not blue in 12 tutorial?????
HAPPY BDAY ! π
What the hell just happened ππππ
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!!
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.?
Thanks man! You're a great teacher