SQL Tutorial - 12: Inserting Data Into Tables

In this tutorial we'll learn to insert data into tables using the INSERT INTO statement.

[@Zer-py2dk]

After i heard his voice, i knew my search is finally over

[@Terawaycomm]

This tutorial is very helpful to me it really brings success to my coding journey thank

[@tersiasnoer7250]

What mySQL statement can we use to insert a selected row in a JFrametable into a mySQL database table?

[@patriciamarch5872]

Thank You for your video, I am taking SQL Database Class right now!

[@binodpradhan4230]

Hello I just added new column in my table and showing null .how can I insert values to my new added column

[@mahakjain4380]

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

[@santosh4471]

Thanks man! You're a great teacher

[@abhisheksaini2045]

Thanks for the information...but I have a one query suppose I have to delete data from serial no.of table not from I'd ,name etc.then what command should be used ?

[@johnilagan05]

what scripts will i use for inserting in many tables ? is that possible ?

[@vani_agarwal]

Can we instert more than 1 person information in the same table by using the format ??

[@yasirjune69]

Thank you so much...it was really informative and convenient video.

[@ganeshsailalithkumarpathan8570]

Thanks a lot for the tutorial. how can i insert data into a particular column ....if there was a column called experience at that time how to insert the data??

[@brandonhuitt929]

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

[@chaitanyareddy9391]

y are u using semi-colon for date-time datatype .may i know sir?

[@srinivasaraoyp3640]

Very interesting tutorials. Thank you.

[@vidyasagargaikwad1268]

I have two tables I want to insert values in second Table with the help of first table so how can i. Please tell me sir

[@surajahlawat1688]

Can you please tell me why the "name" column is blue but other columns like id , dob are not blue in 12 tutorial?????

[@ymy109able]

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!!

[@swarnim_n_shreyan3625]

1iiwoeoeow887⁷

[@ashwetdeshbhratar2522]

which software are you using???

[@tikendersingh1138]

3:52 why "name" is appearing in blue and rest of the column names are normal?

[@Ranjithrd12]

Thnx for this wonderful video man , it was really helpful... 💜

[@devnderkashyap5756]

Thanks buddy,your videos helping me alot..

[@smrutiranjanparida9766]

which version are u using, looks so easy on that

[@muskansaxena8531]

Columns not allowed here error are come how to solve problem?

[@aarifz311]

Anyone know how to insert Array into database ?? Something like maybe INSERT INTO TableName (column 1,column2) VALUES ('Arrayone','Arraytwo') To fill the rows

[@kalyantarafdar8719]

please help me to download the version of sql database you are using please

[@akhilagarigipati7881]

Which s/w u used

[@sumitparmar805]

Which app do you use??

[@L4R_Pandey]

in which platform u use this sql

[@gauravsingh8274]

Sir jaise MySQL ke under insert into main sab daal diya mujhe show bhi kar raha hai but phir MySQL band kiya uske baad open toh same page khul gya so last main kiya tha par main uske aage aur entry daal raha hoon toh kyu error show ho raha hai sir please help me main aapko send bhi kar sakta hoon image jo main kiya hai

[@shikha8081]

I am not able to insert values in the columns. It says column "id" of relation "employee" does not exist. Can you help me with it?

[@codedaily365]

Happy b'day man!!! lmaoo what a coincidence

[@Afalaa]

Excellent tutorial. Liked it and subscribe to your channel.

[@Sarabethd]

"what the hell just happened" .. story of my life LOL Thanks so much. Very helpful!!

[@madhurbhatia89]

Thanks for watching!

[@liliabera4202]

In our computer what do u need to download

[@stefmyt5062]

Thanks man, this video helped a lot!

[@zezo928]

Great explanation comparing to others

[@bhaticourier7080]

Thank you so much ..... your video today is also helpfull.

[@rajcable3204]

Thankyou so much Sir sql commands smjh ni aa ri thi ab 5 me se ek aa gyi😂😂

[@neerajdhar8537]

thanks i got the job even though i was from mech background love u bro

[@f.a5148]

Great tutorial thanks a lot man.

[@nikitarathod5224]

Thank you, you are amazing..!!!!!!!!!!

[@Top5Category]

Awesome tutorial !!

[@clevencedsouzagupta4121]

Thanks sir for providing this !!!

[@McGavel1]

Awesome, thanks!

[@kalpeshsajnani9952]

very informative video bro

[@aishwaryaubale5148]

Where is the tutorial series sir from 1 to end

[@its_nikhil_]

Thanks sir tomorrow is my practical

[@arshdeepkaurarsh504]

really helpful 👌

[@samuelherlander6903]

HAPPY BDAY ! :D

[@rudomuchenje8537]

Waaala.this was apiece of cake for me.Easy to understand for beginners

[@akankshadubey722]

Shouldn't we mention the name within double quote???

[@Crazy_famdam.1903]

Why you named your Chanel the bad tutorial🤔

[@cipherzerone258]

Thank you a lot sir .Bless your soul 😊

[@madhurbhatia89]

Thanks for watching!

[@Sakinah768]

Is this MySQL?

[@VishalSinghRajput]

Hey Madhur tomorrow ur having ur Birthday ;)

[@dineshhsharma2764]

can u make more videos plsezz

[@hashaamkhurshid3614]

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

[@alkalipher8409]

Thanks a lot bro

[@nargeesansari6337]

thank u sooo much sir

[@mrmendabest]

happy birthday in 3 days :)

[@nand99999]

Happy Birthday

[@sabasaddique4.4]

Table create hogaya ha lakin data insert nii horaha

[@abdullatheefabdulbasith9688]

thanks my dear

[@ashokmarepally3134]

Sir, can u solve this problem ? PREMISE: An SQL table has 4 columns: product ,region ,province, price. The region column can be either National or provincial .If region is provincial then province is filled(e.g.Ontario),otherwise it's blank. Each product has one national price, but may have zero or one provincial price. If a product has no provincial price, the national price is used. For example, "kale" may have a provincial price of $5.99 in Ontario and a national price of $4.50, with no other prices. If a user wanted to find the price of kale in Quebec they would get $4.50. CHALLENGE: Create a method, with a name and signature, that finds the price of a particular product in a particular province. Add the logic in pseudo-code to the body of the method. Be sure to include input parameters, a return statement, and any validation or exception handling that you deem necessary. You can represent the data as an array of objects.

[@meghabahansamal7697]

I can do

[@Top5Category]

How can we insert multiple values in table??

[@chaitanyareddy9391]

we should use insert query as many times we want to insert data

[@livio7024]

Happy birthday Madhur

[@user-vm3zv4bv3z]

Happy bday

[@noffar23]

Thank you!

[@thuppadalokanath5444]

tq so much sir

[@fortisleo]

the bad tutorials are really good XD

[@OnlyThomasHayes]

Thank you.

[@abdullatheefabdulbasith9688]

nice explan

[@simranjha7581]

We have the same birthday bruh😂😂 ✨✨

[@amandeepmishra3107]

Thanks man..

[@kritypandey5331]

thank you

[@Dusnsbsjiw92]

thank u so muchhh

[@dineshhsharma2764]

advance and sequencial sql tutorial

[@jitendragupta-bm2fe]

Hi, How can I download MySQL Workbench?

[@meghabahansamal7697]

Tq sir ❤

[@reddygaariabbai5410]

brother how to give phone number details into table plz tell me how to give phone number

[@mohamedsalah8781]

yes i like it

[@aussieraver7182]

If DESC doesn't work, then use sp_help

[@kanishkagupta5801]

what data type is to be used is email id also contain numbers with characters..

[@mateuszlesko5301]

id = int, email = varchar

[@__-to3hq]

tanks

[@ffgaminga1811]

This video is very good

[@madhurbhatia89]

Thank you!

[@bajidkhan3703]

Happy Birthday 🎉

[@madhurbhatia89]

Thank you!

[@wafaalz515]

What the hell just happened 😂😂😂😂

[@producedbyshook]

🤣🤣🤣

[@prakhar9886]

@@producedbyshook ager aese har bar likhenge to ho gya kaam

[@producedbyshook]

@@prakhar9886 kya hogya be kyu chichiya rhe ho

[@alexautry3676]

Lmao I laughed at that when he said it and noticed your comment at the top!!! I subscribed

[@mysticjunior2640]

😂 I was about to comment that

[@lilianengandhi3912]

Amazing treaning

[@siri1791]

Tq bro

[@siri1791]

This very helpful for me tq u

[@ximaah]

This accent is so fucking funny hauhauhhau

[@AmitAgarwal1977]

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

[@caravimahtele5474]

Sir how can we insert multiple records by typing values of all fields, like Name Class Mob.No Ram 12th 999999 Shyam 10th 100000

[@nicholasbaker3675]

exactly like you just did but with proper syntax: insert into table_name (name, class, mob.no) values('ram', '12th', 999999) ,('shayam', '10th', 100000);

[@tariqashraf7575]

how i can name it as "the bad tutorials" ? LOL

[@rjphysics5411]

You have not single sign of teaching 😅

[@user-vm3zv4bv3z]

Happy bday

[@petardimitrov4528]

thank you