HomeОбразованиеRelated VideosMore From: CodePotion

MySQL Tutorial for Beginners - 2 - Adding Data to Tables in a Database

1788 ratings | 426163 views
MySQL Tutorial for Beginners - 2 - Adding Data to Tables in a Database Mysql Beginners Tutorial is an introductory tutorial series that features all basic mysql commands necessary to manage a database. For Adding data to tables - INSERT INTO table_name(field1, field2, field3) VALUES('value1', 'value2', 'value3'); To view table content - SELECT * from table_name;
Html code for embedding videos on your blog
Text Comments (129)
Pankaj Joshi (7 days ago)
How to insert data column wise. Say we insert in 1st column then insert in 2nd cloumn , n then 3rd column
Bruno Alves (1 month ago)
thank you bro, even years before I needed, the Lord sended you to bright for those who search for knowledge
Nehal Gupta (2 months ago)
Sir हिंदी bol lia kero
Lanida (2 months ago)
Thank you! very usefull and simple explained! I've my MySQL exam tomorrow... Wish me luck! :)
Bruno Alves (1 month ago)
+Lanida Nice, I've learned that's way: practice! practice! practice! til get in our head! Good studies for all us
Lanida (1 month ago)
+Bruno Alves I guess it was OK. There were some exercises that I didn't practice, 'cause I thought that is not thaaaat important xD but I was wrong
Bruno Alves (1 month ago)
How did you go on the exam? I'm started to learn mysql last year, but it was being very difficult for me.
Gaurav Choudhary (2 months ago)
GOOD LUCK
Dennis Asamoah (2 months ago)
awesome tutorials
Jayant Kanojia (3 months ago)
thanku so..much sir for this video i just all it ...
The Cinebuzz (3 months ago)
Bhellu😂😂
hT GAMER (5 months ago)
i honstly dont understand anything you say.. fix ur voice
Despite the voice, you can turn on the subs/cc ^^
NEMESIS PRIME (5 months ago)
i dont know why people dislike this , he told everything which is neccessary
Triple A The Broski Bro (5 months ago)
Thanks a lot bro............ I'm guilty for judging ur Nationality at 1st but u proved me wrong. Shukran ☺😎
thank you! it works
Adari Das (5 months ago)
Can it doesn't able to store multiple data at one time
Lanida (2 months ago)
You can. Just try it out.
Jet Ezra (6 months ago)
thanks but commanline is still my prob
Anuj Kumar (6 months ago)
thanks for the video(^_^)
Rons Tutorials (7 months ago)
Hey all, I made a tutorial that covers how to add data to a mysql database using Java. Come check it out and let me know if it helped you!: https://www.youtube.com/watch?v=ohOPyXZlsB0
king no.1 (8 months ago)
Mukhe ap se bat karni he
king no.1 (8 months ago)
Ap apna Whatsapp no. Doge
Amit Agarwal (8 months 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
Bharat Kumar (9 months ago)
Request you, remove the wallpaper of your desktop coz i can't watch your video in my office.
Sri Sre (11 months ago)
Good Work. For more please visit. http://www.mysqlqueries.com/
Fisca Anjelina (11 months ago)
nice video and tutorial make anything easy visit www.atmaluhur.ac.id
Prerna Ranjan (1 year ago)
How can I download on my laptop
Sergiu Andrei Sabou (1 year ago)
Man, you have just made my day!This puzzled me a long time and I could not advance with my project.Thank you a lot and long live India!
Hinokio Dokidoki (1 year ago)
Hello i'm new here sorry for asking why you using cmd to create database rather than phpmyadmin? Is that because is it an easy way using cmd?, i dont mean to be rude or something it's because my english is not good enough.
Sagar Vishwakarma (1 year ago)
I Remove All My Doubts About This Topic Now I Am Able Top Now
Raman Thakur (1 year ago)
Nice video
Sree vidhya (1 year ago)
After insertion of values how to save them..?if we shutdown our system..it is not displaying values..which we had inserted earlier it is showing as...empty set..
PAUL WALKER (6 months ago)
Sree vidhya it will automatically saved you can just open your database and type show tables; after that insert*into table value and bla bla bla
Anuroop Madhusudhanan (1 year ago)
Thanks a lot, board practicals tomorrow, helps a lot
Universal Technology (1 year ago)
Thank You Very much sir.its easy to understand.
boiniq (1 year ago)
how do you set up multiple foreign keys?
Tef (1 year ago)
Great video!! Thank you so much!!
cabdulaahi maxamed (1 year ago)
waxa mid ahay ddka media a
Aba nyarku (1 year ago)
Thanks job well done.
Juan D Estrada (1 year ago)
hi, when I insert the values, the first row in the left, which is varchar (50) won't completle show... most of the values show incomplete, only a few letters. why is that?
Achintya Ray (1 year ago)
Bhai how to install MySQL in our PC
mehul mangroliya (1 year ago)
downlod khase hoga link bhajo
Andrew Lee (1 year ago)
Great video series. Easy step by step! Thanks
Roshan Vivek (1 year ago)
ur vids helped me 30 /30 in ms 12rh cs practicals thx a ton keep it up
Shivam Kumar (1 year ago)
Thnxxxx
foster katundu (1 year ago)
thanx
DROIDPLAY (1 year ago)
simple and effective but explan everything while writing ..
Ola Olanipekun (1 year ago)
Thanks a million!!!
Mani Mani (1 year ago)
i wanted to ask " How to insert a value in the column which i have added later, in a particular row?"
AJ (1 year ago)
thanks bro easy to understand😎😎
ankit kumar tiwari (1 year ago)
sir I want to connect mysql with java application but I am finding a lot of problem for get connection to my java application so plz tell me about that
ankit kumar tiwari (1 year ago)
I have subscribed sir
Ricardo Souza (1 year ago)
Excellent explanation!
the best Thanks a lot of U.
Intezar Afridi (2 years ago)
Excellent sir...!!!today i have paid fine for that reason.how to insert data in db....thank u sir
Jon Pounds (2 years ago)
Very nice review. I love your accent... it helps to have text along with voice to follow along :)
Prasun Rakshit (1 year ago)
:D
DEBASHISH JERICHO (2 years ago)
thnq a lot it clears all my douts in mysql
Pierre Kinfack Tetsowo (2 years ago)
Liked and Subscribed ..More such videos please.
Pierre Kinfack Tetsowo (2 years ago)
Superb...Was able to summarise my 12 hours MySql classes in 2 hours just by watching and practising your great videos. Well Done Sir.
M Sadath Ali (2 years ago)
Video not clear
M Sadath Ali (2 years ago)
Thank u, its easy to understand.
hsu marcus (2 years ago)
REALLY USEFUL VIDS. THANK YOU SO MUCH.
Rick Cable (2 years ago)
Good videos! Thank you!
Aman Giri (2 years ago)
thanks
Aditya Singh (2 years ago)
Very nice video tutorial series, thanks :)
Sunil Yandrapu (2 years ago)
HOW TO GET HOST NUMBER?
Vandana Yadav (2 years ago)
aizm
Amitanshu Pattanayak (2 years ago)
sir how can i save my progress in mysql as i am finding it very irritating to do everything over and over again
aman jain (2 years ago)
use following command and thank me later: MySQL>commit;
Om Bhor (2 years ago)
good video but english sucks
Simonmonkey z (1 year ago)
Very Good video and good grammmar but no good pronouncing
leisha ijaz (2 years ago)
really ???
Hardipinder Singh (2 years ago)
what does the u and p during login stand for ?
Alexander Stamm (2 years ago)
user and password
Saidul Karim (2 years ago)
thank you.
Tim Proeber (2 years ago)
Thank you very much!
ming yang (2 years ago)
thank you,i hope you can make more videos!!!!
Don Key (3 years ago)
Thank you for making me understand the basics of MySQL :)
Genius ES (3 years ago)
its truly amazing easy to understand. have liked it.
Emmanuel Iyede (3 years ago)
Thanks a lot... Very helpful
jimber nicolas (3 years ago)
sir my mysql in xampp didnt running. what should i do?
John L (3 years ago)
Very good. Easy to understand. Thank you. I've subscribed
Judy Agcaoili (3 years ago)
Thankyou so much <3
loverze aprie (3 years ago)
very helpful.. thanks sir..
Mazed Hasan6070 (2 years ago)
loverze aprie
abegaz astatke (3 years ago)
this is the bset for ours
Adrian Perera (3 years ago)
Excellent !!!!!!!!!!!!!!!!!!!
AnimeGeek (3 years ago)
i have a request, could you please make a tutorial to create a database using superclas and inheritance, im using a superclass named person and my two subclasses are workers and administratives, and i dont know how to implement it in my db. Thank you in advance
mudasir kumar (3 years ago)
very very excellent and very helpful vedio for beginners
Conor McGregor (4 years ago)
When INSERTING values what value to put in "id" ?
E F X (4 years ago)
+Kerim Madison it is set to auto, so you don't insert any value for 'id'. This is why he is specifying the table columns in the parameter. If you didn't need to 'skip' the 'id' part, you could just insert into tablename values( val1, val2, val3, val4) but since the 'id' setting set up at the creation of table is set to auto_increment, you will need to specify the other 3 columns before including values. I haven't tested inserting manual values on an auto_increment column, however it may work? Test it out?
stsinner05 (4 years ago)
thanks
Raj Gopal (4 years ago)
very good video, thank u so much..
Marrol Flores (4 years ago)
THANK YOU PAPI.
Benjamin Adebowale (4 years ago)
thank you very much man you really helped but my only question is why don'n you use workbench because the codes work perfectly when i use workbench.
Ted Baxter (4 years ago)
Thank you .  That helped me.  Trying to connect a database to java.  I just needed a test database :)
Kyle Young (5 years ago)
this guy is a real big help for my studies i salute you sir!!
aditya sethi (5 years ago)
:).........u entertained a lot..
SourceInfoKing (5 years ago)
Big Help thanks sir
Hannzon Hubby (5 years ago)
sir can you give us some outputs or finish product of this program...
Pinaj Kujur (5 years ago)
Tutorial Makes Any thing Easy .. Indeed Thank u Sir
Carlos (5 years ago)
thank you sir, you helped me a lot!
azmin min (5 years ago)
thnk
Jayesh Dulani (5 years ago)
super !!!
Sridhar E (5 years ago)
nice
AnImErOcKs360 (5 years ago)
Toterial
AnImErOcKs360 (5 years ago)
Thanks for that good laugh:)
Richard Dean Canoy (5 years ago)
Sir thank you for your kindness for sharing your thoughts on us viewer my Lord give you a blessings.
Lords Of The Sith (5 years ago)
great video easy to to follow, but your english accent needs alot of work bro!
Deo Icao (6 years ago)
thank so much sir ....may God give you more blessings......
Sue Love (6 years ago)
great videos! have caught on more from watching your demonstrations than I was from a book - thanks!
stillarmed (6 years ago)
Thank you for the excellent tutorial!
Hirdesh Sharma (6 years ago)
hanks its very helpful

Would you like to comment?

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