MySql Tutorial: CREATE database, add table & INSERT VALUE

How to create database and tables in MySql using the terminal on UBUNTU ...
Find more MySQL tutorials at my website
mysql -r root -p
enter your password
SHOW DATABASES;
CREATE DATABASE name;
USE database_name;
CREATE TABLE name (fields and their data types);
DESCRIBE table_name;
INSERT INTO table_name VALUE(field values);
SELECT * FROM table_name:

[@farajshaikh5100]

This is the simplest tutorial I've found on youtube. Thanks a lot!

[@MultiPCGamingVideos]

Thank you so much, great tutorial. I have googled and searched for this for hours and just couldn't understand it. After watching this video it's so easy to understand. Great job, thumbs up!

[@viniciusgustavo1869]

THANKS MAN, You really help me.

[@fendergx7422]

Thank you! it's simple and the better for learn this!

[@alvarocafe]

Love to hear you saying you love Ubuntu. I love it too. Cheers

[@DesuWest]

AWESOME SIMPLE video! HELPFUL it is very much so. THANK YOU!

[@ontariobeaver9376]

Thank you! You are the man!

[@tertiusakademia5360]

Thanks my dude, this video helped me break through the database barrier.

[@jobacaye3300]

Think's so much have began to like MYSQL, whish you upload more videos.

[@johnbritolima]

Pretty straight forward. Thanks.

[@daksh9718]

THANKS MAN, You really help me. was struguling how to create table, this really helped, good job. THANK YOU BOSS,ITS REALY HELP ME. Thank you! it's simple and the better for learn this!

[@TubeMint]

You are welcome!

[@tanoojboyapally8216]

I tried many times before watching your video but it got success now thank you so much 😎😎😎👍👍

[@cocovibes3868]

WAS HELPFUL FOR MY EXAMS. Thanku...

[@martinkilonzo3357]

Thanks so much,, I was not able to create a table. But have understood everything now. Thanks so much

[@peppermintdior]

helped a lot before my practical ty :)

[@diviya.c4393]

Videos of mysql queries was nice the video was helpful to me for my practical examinations

[@tobiba3484]

01:10 Update ... with Ubuntu 18.04 and mysql-5.7, the default method for a mysql root login has changed ... type
sudo mysql -u root
Thanks for posting this, good one

[@aradhanasamara8469]

it was really helpful. thank you!

[@tobiba3484]

Very well explained, thank you

[@rogersmith258]

Thanks bro, you're a lifesaver! I am doing MySQL for an internship and needed to figure out how to create a database that a chatbot could sync to.

[@TubeMint]

Good luck!

[@rogersmith258]

@@TubeMint Thanks!

[@rogersmith258]

@@TubeMint Thanks, I'll need it!

[@baldovincadenamejia244]

@@TubeMint If the language row is ENGLISH by default, then why could you write 'Hindi' for the book you wrote in the database ?

[@ephraimetuk9670]

@@baldovincadenamejia244 really ?

[@SakshiKumari-xk3zg]

Thanks! This helps alot🌸

[@MichaelGTadesse]

short and succinct , thanks!

[@ioannismarkoulakis4978]

Finaley someone who does it clearly and fast.

[@madsquirrelmods3035]

Don't get me wrong. I love it when things are deeply done in detail and slow; but when it comes to coding and programming, I prefer having it fast. So, I agree.

[@sugrivlodhi2607]

THANK YOU BOSS,ITS REALY HELP ME

[@muhammadarslanghafoor3542]

Great Work Bossssssssssssssss!!!!! Helped alottt

[@godwinadade8166]

in fact this is a good video for every beginner, it very helpful. thanks very much. can i get a link to the continuation ( i mean the next thing to know after this create and insert tut)

[@nirajmali4482]

Thankyou sir, that helped alot

[@adrienneparks9791]

Great video! Thank you!

[@TRADING-BANKNIFTY]

good video it was very helpful thnks

[@jijireghu1741]

Thank you mate...

[@NigerianBaller]

PERFECT. CRYSTAL CLEAR INSTRUCTIONS 👌

[@AKvibes]

Literally thank u so much brother,❤️❤️

[@daksh..]

Thank u so much bro love u🙏

[@pm8521]

Very useful tutorial. Thank you

[@santoshbasnet9658]

Thank you so much sir.

[@sindhunithu8484]

very helpful...thank you

[@golamrabbany8011]

it was helpful.Thanks.

[@xfce4491]

Thanks it really help me..

[@monabbulislam1962]

Thank you bro your video is very helful

[@Dame1122]

Great video!

[@aratamo7830]

Thank you so much best tutorial 😊

[@xaviercortez5625]

outstanding!!! a good simple process to follow.

[@Loopysoloist]

Really helpful video. Thank you! Straight forward, simple, and informative.

[@BlackStarSeries]

I have learned basic Linux fairly comfortably. I am currently learning basic SQL, maybe you can help me out. Quick question. Should I use the terminal to write SQL queries/databases/etc?

[@TubeMint]

Yes, use terminal

[@BlackStarSeries]

@@TubeMint Thank you!!

[@TubeMint]

Welcome!

[@randommeme7632]

thanks man your video saved me :)

[@rajendrapalled268]

Useful. Thanks, Sir.

[@emanuelhembram4294]

Thk for the great help🙏🙏🙏🙏

[@siddhantnaik5545]

THANKS dUDEE
you helped me
a lot.

[@yashgupta7041]

how to move up a line in command line? please tell me

[@praveenkumarkamineni1057]

Thank you 💓 brother

[@tntxqx8281]

thank you it very helpfull

[@fluidman777]

Thank you!!

[@netneedingsystems2318]

Thanks!

[@FERGIOH2010]

Great video, very well described.

[@TubeMint]

Thanks,

[@puneetsehjal]

Thanks alot ❤️☺️

[@dariomilani9241]

thank you so much your video was so clear and helpful

[@TubeMint]

Glad it helped!

[@atuldwivedi7677]

Thankyou sir 🙏

[@subhrangshubanerjee]

Thx a lot sir

[@poojapoojadhapte1430]

Now its so beautiful so elegent just looking like a wow

[@anupamasinha7607]

It's very helpful

[@anisha.s7425]

Thank you bro

[@vovs03]

Thanks! Watched.

[@TubeMint]

Thanks for watching!

[@sydneywoodruff7188]

Is there a way to add another field after making the table?

[@arpitgoyal1979]

Thank you so much! I think you should put "mac" "osx" "bash" "linux" keywords in your description to get more views

[@shyamu431]

Thanks bro

[@mrs.random8095]

Thank you dude

[@iankamandew9777]

Thanks alot

[@ROC4Life96]

Shouldn't price by a FLOAT?
thanks again for this video!

[@olayinkabusari6019]

Thank you very much, bless you.

[@TubeMint]

Thank you too!

[@anuragkothare6181]

Thank you really helpful

[@TubeMint]

+Anurag Kothare welcome

[@dilshodboboqulov354]

Thanks Bro))

[@hiwaabdolahi2780]

Tnx :)

[@ROC4Life96]

Thank you,. Also i'm operating in mac os and have been thinking of switching to linux (especially since i have a growing interest in deep learning), my only concern about linux is the amount of apps available to linux in comparison to apple. What's your opinion on Linux vs. apple? I'm glad to hear from any/everyone!

[@saileemani9312]

thank u sir

[@asiphenqinana5561]

Very helpful

[@tusharsatpaise6628]

Thank u so much 😊😊😀😀😀😀😁😙😙😙😙😙😙

[@MultiKarthik619]

thanks man

[@nathalievanbellegem5313]

You may have just saved my examn

[@riadb8281]

please, i looking for a shell script to insert data into mysql database. Can you please share. thanks.

[@abhinavajesh1196]

which app should i download.i am using windows

[@adriandanutvranciu8506]

Thanks dude

[@esargf]

If I want to create a table for example, Field is status, Default is 0 and Extra is 0:active 1:inactive. How do I add ' 0:active 1:inactive' to the Extra?
I tried mysql> create table test(status VARCHAR(1) DEFAULT 0 EXTRA 0:active 1:inactive); but it doesn't work. Please help.

[@haobasalam792]

Hello sir! plzz give me the link... about this software...

[@akanshakumari7650]

will pl/sql will work on mysql server?

[@raihanrony1810]

how to you clear screen while in mysql tho??
im new .

[@berserken1444]

At 5:07, after the opening bracket you continued the command to next line starting with "->" . How to do that?

[@ankitranjan88]

Really thank you Very Much

[@TubeMint]

Happy to help

[@yashgupta7041]

how to move up a line in command line? please tell me

[@juant1804]

Thanks

[@Ramsey.001]

How can i get databases preview in a browser ?

[@farahmoha1132]

THANK YOU SO MUCH MAN !! YOU HELP ME EXACTLY ......

[@arshadprakashan]

Is there any queries to insert pics or videos like this

[@shrutiguldagad1012]

How did you go to the first line again at 4:11 ...?

[@1jovi3]

cls maybe

[@dxpgaming5975]

It really help me a lot
Thanks😀😀

[@mahadevan4790]

So how to create multiple rrows

[@naffetiahmed7855]

Thank you

[@TubeMint]

+Naffeti ahmed wëlcome

[@MRGAMER-sg6of]

bro can you make a video how to download the software mysql.and thanks for the video it helps me a lot

[@TubeMint]

Hey? Already created a video how to install MySQL on Ubuntu. Find it on my channel page..

[@epicultra1519]

How to download this MySql

[@dilshodboboqulov354]

I'm from Uzbekistan)

[@rejimon1703]

Thxx

[@Mem23381]

thumbs up

[@Thesupergeeeks]

Merci beaucoup j’avais oublié toutes les commande de mysql ça fais longtemps que j’ai plus fais de la database merci pour le rappelle

[@jakubuhnak1739]

best