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

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;

[@ujjwalkumar284]

9 years past you described so nicely that present we are following you...I request you to kindly expand more and elaborate more in mysql

[@innosphere1905]

What my college teacher didn't explained in 3 hrs you explained in just 6 minutes🥰🙏

[@xavier2130]

That too 9 years ago

[@observantmagic4156]

Bruh you need a new college teacher if they are that bad

[@uditmahato1688]

They are not bad . I guess they English is not understandable by me

[@TheNangaboko]

Superb...Was able to summarise my 12 hours MySql classes in 2 hours just by watching and practising your great videos. Well Done Sir.

[@WallaceThiago]

nearly 10 years already and i'm still learning from this video..
amazing

[@aishwary2047]

i dont know why people dislike this , he told everything which is neccessary

[@ch3atz939]

what my school teacher couldnt taught me in 4 months,you taught me in two videos

[@littlemang69]

this guy is a real big help for my studies i salute you sir!!

[@suelovesdc]

great videos! have caught on more from watching your demonstrations than I was from a book - thanks!

[@enockssembajja77]

its truly amazing
easy to understand. have liked it.

[@yukiprincess57]

Thank u bhai u explained very well u made my day I am bca student and I can't understand I my class but u are amazing thanks bhai thank u so much

[@roshanvivek1375]

ur vids helped me 30 /30 in ms 12rh cs practicals thx a ton keep it up

[@mpfaasaleleaga2]

awesome tutorials broda...keep them coming...you are changing someones life and career with these tutorials....so thank you!

[@l.lani.i]

Thank you! very usefull and simple explained!
I've my MySQL exam tomorrow... Wish me luck! :)

[@Gaurav-hi8wt]

GOOD LUCK

[@l.lani.i]

@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

[@sergiu2325]

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!

[@happyworld2904]

Really good work. My task completed easily with your great guide. Keep it up. Allah bless you Amen. Am your new subcriber :)

[@francisbacon4363]

By the looks of it GOD has already blessed this guy

[@erjohbejuco6458]

you teach this lesson way more better than my prof thanks sir

[@DJJSerpico]

Very good. Easy to understand. Thank you. I've subscribed

[@amartarei4357]

Thank you very much, it helped a lot 😁

[@BenjaminAdebowale]

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.

[@songsworld9722]

thank you sir very much you helped me a lot once again thank you sir

[@anuroopmadhusudhanan9795]

Thanks a lot, board practicals tomorrow, helps a lot

[@pallavigupta660]

Very helpful and nice explanation video thanku so much .🙏🙏🙏

[@pinajkujur6837]

Tutorial Makes Any thing Easy .. Indeed Thank u Sir

[@ahmedaden2537]

GOOD

[@_SurajYadav-lr9fl]

thanks for making such video bro it is very helpful for me

[@andyleelee1]

Great video series. Easy step by step! Thanks

[@silenteyegaming3697]

very very excellent and very helpful vedio for beginners

[@AnthonyOsula]

Good work - you make it easy. Thanks and keep on posting more.

[@sashales8916]

thank you very much!!! I though that you also need to enter Id and always has an error. Thank you 🙏🏼!

[@triplea7071]

Thanks a lot bro............ I'm guilty for judging ur Nationality at 1st but u proved me wrong. Shukran ☺😎

[@bradg0620]

Insert data into tables starts at 2:10 . Thanks a lot man, nice work!

[@stillarmed]

Thank you for the excellent tutorial!

[@Premansh_tak]

danm bro since 11years nothing is changed

[@mrjkd74]

amazing video. btw your wallpaper selection back then was goood.

[@ricsharkbrazil]

Excellent explanation!

[@rushne22]

Sir thank you for your kindness for sharing your thoughts on us viewer my Lord give you a blessings.

[@xperrosinsangrex]

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?

[@tef7474]

Great video!! Thank you so much!!

[@Deba_447]

thnq a lot it clears all my douts in mysql

[@songsworld9722]

it was very helpful

[@mechaadi]

Very nice video tutorial series, thanks :)

[@prashutiwari3834]

कितने साल पुराना वीडियो लगता नहीं ऐसा लगा है कि अभी क 😮🎉ह

[@inhibited44]

Thank you . That helped me. Trying to connect a database to java. I just needed a test database :)

[@ankanarasimarao7322]

thank u bro it is easily understand

[@adityakiran1377]

And there is no mistake in my sql command

[@misa250]

thank you sir, you helped me a lot!

[@odix76057573]

Straight forward

[@justmelol2010]

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

[@jonlbs7]

Very nice review. I love your accent... it helps to have text along with voice to follow along :)

[@prasunrakshit]

:D

[@ManiMani-ly9cf]

i wanted to ask " How to insert a value in the column which i have added later, in a particular row?"

[@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

[@INGLEANDSONS]

Thank you sir thank you so much

[@hinokiodokidoki7013]

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.

[@mingyang6817]

thank you,i hope you can make more videos!!!!

[@universaltechnology1845]

Thank You Very much sir.its easy to understand.

[@aprilroseang2917]

Hello ,may I ask how to add another column in a table? Thank you 😊

[@marcus48134]

REALLY USEFUL VIDS. THANK YOU SO MUCH.

[@msadath09]

Thank u, its easy to understand.

[@rajgopal9249]

very good video, thank u so much..

[@nvision.studywithfun872]

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

[@mkafridi5471]

Excellent sir...!!!today i have paid fine for that reason.how to insert data in db....thank u sir

[@anu_Vlog43]

Thank you sir 🙂🙏

[@adrianperera9901]

Excellent
!!!!!!!!!!!!!!!!!!!

[@Jay555vlogs]

thanku so..much sir for this video i just all it ...

[@CyberAbyss007]

Good videos! Thank you!

[@archishman4073]

you had a great taste in wallpapers bro :(

[@dennisasamoah2213]

awesome tutorials

[@TheNangaboko]

Liked and Subscribed ..More such videos please.

[@emmanueliyede8721]

Thanks a lot...
Very helpful

[@SourceInfoKing]

Big Help thanks sir

[@BigDSpammer]

simple and effective but explan everything while writing ..

[@Aj-ih6gr]

thanks bro easy to understand😎😎

[@jimbernicolas9088]

sir my mysql in xampp didnt running. what should i do?

[@olaolanipekun3544]

Thanks a million!!!

[@dhrjkmr5]

thnksss sooo much 4 excellent videooooo

[@anushka20100]

thank you so much for uploading this , it help me a lot.:)

[@mbaye501]

wow so helpfull God bless

[@phitchaphalertsiravarameth8765]

thank you! it works

[@abanyarku167]

Thanks job well done.

[@manojrawat9939]

How to insert multiple row with single insert into squery

[@kingstar-ev3uz]

Hi sir one doubt how to get printout in this screen pls rply me sir

[@mrezvanpanah351]

the best Thanks a lot of U.

[@sreevidhya2484]

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]

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

[@vinsham2523]

thank u so much.but,will u plz tell me whether it necessary to write insert into command each time when we want add data

[@yt_bimalmagar69]

Thank you

[@user-dn9kl4xb6c]

I Remove All My Doubts About This Topic Now I Am Able Top Now

[@TomoriNao_]

Tq lifesaver

[@randomgameplay647]

Nice video

[@khatariinsaan5284]

College is only for attendence
Actually We learn things out of the college

[@loverzeaprie1163]

very helpful.. thanks sir..

[@MazedHasan-tg2kv]

loverze aprie

[@technoterms]

👌👌

[@Aryan-27.]

Term2?

[@boiniq]

how do you set up multiple foreign keys?

[@hirdeshsharma8812]

hanks its very helpful

[@mohitjain121188]

thank you sir this video is very helpful for me. keep posting sir. :-)

[@adityakiran1377]

Please give me the answer quickly

[@avengers4959]

Suggest Books in DBMS, mySQL for B.Sc .. .

[@hannzon]

sir can you give us some outputs or finish product of this program...

[@BHAWANISINGH-gi6jw]

Sir please tell all the command of database

[@BHAWANISINGH-gi6jw]

Actually I am new to the subject class 11

[@amaulik2512]

thanx a lot.......

[@smarkie2910]

you're a goddddddddddddddddddddd