SQL Tutorial - 12: Inserting Data Into Tables

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

[Zer-pydk]

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

[ymyable]

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

[Sarabethd]

"what the hell just happened" .. story of my life LOL

Thanks so much. Very helpful!!

[patriciamarch]

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

[codedaily]

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

[vani_agarwal]

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

[tersiasnoer]

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

[neerajdhar]

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

[santosh]

Thanks man! You're a great teacher

[ashokmarepally]

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.

[rajcable]

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

[Ranjithrd]

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

[bhaticourier]

Thank you so much
your video today is also helpfull.

[abhisheksaini]

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 ?

[yasirjune]

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

[johnilagan]

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

[devnderkashyap]

Thanks buddy, your videos helping me alot..

[binodpradhan]

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

[srinivasaraoyp]

Very interesting tutorials. Thank you.