Create Table, Insert and Select in SQL | MySQL beginners commands (Hindi) #3

How to Create a table in Mysql?
How to Insert in a table in Mysql?
How to Select in a table in Mysql?
SQL queries simple form starting
SQL beginners tutorials
More videos :
How to Download Turbo C++: • Video
Data Structure Tutorial Playlist: • Data Structure in CS
lectures CS #IT cse Gyan NET&JR Simple & Snippets I Technologies Education 4u For you Hindi Easy Engineering Classes Last Moment Tuition class
java tutorials
c programs
c++ course
java classes
data structure
BTech syllabus
polytechnic course IT
Digital Electronics
Digital Computer
#lectures #Simple & #Snippets #Technologies #Education #4u #For you #Hindiclass #EasyEngineering #Classes #LastMoment #Tuitionclass
#java #tutorials
#c #programs
c++ #course
java classes
#data #structure
#BTech syllabus
#polytechnic course IT
#learncode #coding #code
#digital #electronics
#CSE #Gyan #Tutorial #btech #polytechnic #hindi
Please Like Share and Subscribe
CSE Gyan
Cs Engineering Gyan
Teacher: Kailash Joshi
Editor: Bipin Chandra
Thank You

[@jyotishdas2339]

Exam ke doo din age sir ne pure dought khatam kar diye 💯💢 so perfectly explained thanks a lot sir 👍🏻🙏🏻

[@CSEngineeringGyan]

you are most welcome

[@bhargabhaloi3080]

Kal kiska kiska DBMS lab ka exam haii 😂

[@CSEngineeringGyan]

all the best

[@mansiyadav5884]

Meraa

[@Mr_Rajput_rider]

😮😢😢😂😂😊😅😮😢🎉😂❤mera

[@Lk-916]

𝐌𝐞𝐫𝐚 𝐛𝐡𝐢

[@user-rt3fb7bp7j]

😢

[@rawatsd7153]

1 night before exam wale like kre

[@CSEngineeringGyan]

all the best

[@prithvirajkopnar9394]

Abhi tak jitne bhi database ke video dekhe kuch samaj nahi aya lekin aapka perfectly samaj aya ❤❤❤❤❤❤❤

[@CSEngineeringGyan]

thank you so much

[@amatysharma4843]

I had few doubts but thank you sir now I'm confident

[@CSEngineeringGyan]

you are most welcome
please support us.

[@devansh8191]

Thank You So Much Sir 🥰🥰❤️❤️. I have Watched many videos on RUclips but did not Understand anything. But your video cleared all My Doubts 🔥. Thank you So Much Sir 🥰❤️🔥

[@CSEngineeringGyan]

You are most welcome
please support us.

[@patlollaganesh1409]

Msdian❤

[@azhar4038]

Right😊

[@ashleyjackson9865]

I don’t speak or understand any Hindi but I understood everything you said thank you so much, I would not have been able to do my assignment without your help

[@CSEngineeringGyan]

you are most welcome

[@Techbhaktt]

This video cleared all my doubts... Thanks man ❤️

[@CSEngineeringGyan]

Most welcome 😊
please support us.

[@Utkarsh399]

Create table student (name varchar(50) ,roll number int(10),branch varchar (5));
2) insert into student values ( 'Kamal' ,12, 'it');
2) whatever
3) select * from student

[@prof.ankitaagarwal5315]

Awesome..Simple and Clear Step by step Explanation...keep up the good work

[@CSEngineeringGyan]

Thank you, I will

[@yaminibawankar5956]

Thank you so much sir this video is very useful for me 🙂

[@CSEngineeringGyan]

Most welcome

[@Demonmuzic]

Thankyou sir it helped me a lot the way u have told everything is easy to understand🙏🙏

[@CSEngineeringGyan]

you are most welcome
please support us.

[@MA-10]

Helped for my 12th board exam tomorrow 🤝

[@CSEngineeringGyan]

Great 👍

[@DhillonShab-dj9dl]

Bahut achhe se karvate h sir aap

[@CSEngineeringGyan]

thank you
please support us.

[@Iam_DEV-xb9ix]

This video is very useful for beginners like me........... Thanks 👍👍

[@CSEngineeringGyan]

My pleasure 😊
please support us.

[@CSEngineeringGyan]

www.youtube.com/@kailashjoshitutorials/featured
please support our new channel for new tech

[@abhishekvathare7846]

this video gives me lot of information and we all supporting you keep it up sir.

[@CSEngineeringGyan]

Thanks a lot

[@pokemonking1547]

Thanks bro 👍👌👌👌 tomorrow is practical exam I will this channel for MySQL to my class mate

[@CSEngineeringGyan]

Great 👍

[@sultanahaifaparvin155]

Thanks for making me understand

[@CSEngineeringGyan]

you are most welcome

[@a.k.classes]

Sir please voice valum thoda jyada rakha kijiye
पढ़ा बहुत अच्छा रहे हैं

[@CSEngineeringGyan]

ok next time
you are most welcome
please support us.

[@akshaynaidu2094]

Your explanation is very easy to understand. Thank you for clearing my doubts. You have a new subscriber 😊👍

[@CSEngineeringGyan]

Thanks and welcome

[@hellocharlie9169]

Dhanyavad bhai

[@CSEngineeringGyan]

you are most welcome

[@rajeshmodem6097]

yes thanks a lot your video has having perfect syntax and it is working,

[@CSEngineeringGyan]

You are welcome
please support us.

[@aarontirkey1505]

Thank you sir for explanation. Now it has become easy to understand.

[@CSEngineeringGyan]

You're most welcome
please support us.

[@Utkarsh-Shukla]

Mera toh class 10 ka practical exam hai iss liye dekh raha 😂

[@CSEngineeringGyan]

all the best

[@Utkarsh-Shukla]

@@CSEngineeringGyan thanks 😊

[@gamingwithmehtayt2646]

Sir your video is very helpful for me thank you sir 😍💥

[@CSEngineeringGyan]

Most welcome
please support us.

[@CSEngineeringGyan]

www.youtube.com/@kailashjoshitutorials/featured
please support our new channel for new tech

[@yuvigod6699]

Thanks a lot sir

[@CSEngineeringGyan]

you are most welcome
please support us.

[@gxvenom8428]

Thanks a lot sir ,
U seems to be very hardworking person.

[@CSEngineeringGyan]

It's my pleasure
please support us.

[@gxvenom8428]

@@CSEngineeringGyan 🙂

[@pavankulal9980]

Thank you Bhai, it was very helpful

[@CSEngineeringGyan]

Always welcome
please support us.

[@Riyayadav_76]

Thank you Sir 😊

[@CSEngineeringGyan]

Most welcome

[@ishita1806]

Thank you sir vo this video BTW I'm in 12th standard and I want to pursue career in cs engineering and as I have my subject ip and I have studied 3 languages mysql,python and java is it OK to opt cs as my course?

[@CSEngineeringGyan]

yes all the best

[@durgeshshekhawat4222]

Aaj hi DBMS ki exam he bhai😅

[@CSEngineeringGyan]

all the best

[@l.o.stlifeofstudents6071]

Thank you sir for this helpful video👍🙏

[@CSEngineeringGyan]

Most welcome
please support us.

[@ceramicpottery5983]

The table looks more real with shapes option in paint 🎨

[@bisalranjanswain2434]

The way of explanation is just excellent 👍

[@CSEngineeringGyan]

Thanks a lot 😊

[@DEF_ABHI21]

thanks sir jiiiii

[@CSEngineeringGyan]

you are most welcome
please support us.

[@KaranSingh-jc7wi]

Altra pro legends are watching this video before 1 hour for the exam

[@CSEngineeringGyan]

all the best

[@dewansh152]

thanks man you just helped me pass my test tomorrow

[@CSEngineeringGyan]

Most welcome! Keep Learning. Thank You for watching. 🙂 Like subscribe and share with your friends. #csegyan #cs #it

[@dpkramprasad8551]

Very useful and full of content

[@CSEngineeringGyan]

Thanks a lot

[@CSEngineeringGyan]

www.youtube.com/@kailashjoshitutorials/featured
please support our new channel for new tech

[@shadowgaming6180]

Thank you very much sir.

[@CSEngineeringGyan]

Most welcome

[@yuvigod6699]

Simple is beautiful 😍😍🔥🔥

[@CSEngineeringGyan]

you are most welcome
please support us.

[@CSEngineeringGyan]

www.youtube.com/@kailashjoshitutorials/featured
please support our new channel for new tech

[@k_b491]

Bro agar roll number ki jagah branch par where use karna ho toh kya coding hogi please answer
Btw nice explanation keep it up
Ram ram❤

[@sameerpatil5923]

Teaching Level Very Simple
Thank You❤

[@CSEngineeringGyan]

You are most welcome

[@sameerpatil5923]

@@CSEngineeringGyan Keep It up💫

[@RishiKumar-bw2fg]

You are genius sir ♥️♥️♥️very very well done sir 👍👍 thanks a lot mere prabhu🙏🙏

[@CSEngineeringGyan]

Thanks and welcome
please support us.

[@bharatrajpal4219]

@@CSEngineeringGyan mysql>create table employ(name varchar(50),code int(12),post level varchar(50)); sir this is my code and after that when i desc employ the limit that i set in code int doesn't show please help me

[@DhruvAgnihotri-ih7vl]

thank you

[@CSEngineeringGyan]

You're welcome

[@neejanand771]

Thank you bhaiya meri problem solve karne ke liye

[@CSEngineeringGyan]

most welcome

[@user-lu2pi3mk1n]

Thanks for this video.

[@CSEngineeringGyan]

you are most welcome
please support us.

[@AllEdits-bo3pi]

Thank you so much sir 💗😊

[@CSEngineeringGyan]

Most welcome 😊
please support us.

[@kusumlata9008]

Aap to computer wali mam se bhi acha batate hai

[@CSEngineeringGyan]

thanks

[@abhinavgiriproperties]

very good mic sir

[@CSEngineeringGyan]

thanks

[@deepak_arya44]

Very helpful video 👍

[@CSEngineeringGyan]

Glad it was helpful!

[@rahultandale8561]

Thank you for your guidance 🤠

[@CSEngineeringGyan]

You are so welcome

[@Proud_743]

Thank you so much sir ji 🙏🙏😊

[@CSEngineeringGyan]

you are most welcome please support us.

[@pramodchandelpkc]

Thanks for Sharing

[@CSEngineeringGyan]

most welcome

[@user-dv4hb7kf2y]

Nice sir

[@CSEngineeringGyan]

Thanks and welcome

[@saksheejayvindkumarsingh6772]

I want answer of this question please help ....
1) There exists a table BOOKS containing columns Accession number (ASNO,
integer), book name (BNAME character), author’s name (AUTHOR character) and number of pages (NUM, integer) . There exists another table ISSUE containing columns Student number (SNO integer),
Accesssion number (ASNO integer) and date of issue (DTISSU date).
Write MySQL queries for the following:
i) Display the book name, author name, student number and date of issue for the books having more than 250 pages using both the tables.
ii) Display the book name, accession number and date of issue for all the books using both the tables.
iii) Display book name, author name and number of pages from the table BOOKS for those books where the number of pages is above the average number of pages.
iv) Display author name and number of pages in the descending order of number of pages from the table BOOKS.
v) Display student number, Accession number and date of issue for student number 112 from the table ISSUE.

[@Sensei-Saitamaa]

Thanks bro...

[@CSEngineeringGyan]

Welcome
please support us.

[@ravitapandey1364]

Thanks for explaining

[@CSEngineeringGyan]

You are most welcome

[@Mammajiprincess]

Thank you so much sir...very understanding video

[@CSEngineeringGyan]

Thank you so much please like, subscribe and share with your friends.

[@babulusinger1234]

🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏give nice teaching sir

[@CSEngineeringGyan]

Thanks and welcome
please support us.

[@bishwajeetsingh5892]

thank you sir it helped me a lot......
was unable to do anything then this helped me
btw sir aap indian ho na
kyunki aapka channel name mein gyan likha hai

[@CSEngineeringGyan]

yes i am Indian
thank you so much

[@user-rk6ii8jt7o]

Bhai Bahut acha explaination hai. Wish you always achieve your goal.

[@CSEngineeringGyan]

thank you so much
please support us.

[@CSEngineeringGyan]

ruclips.net/channel/UCEO7KQgRI6K6XsyTJlF79nw
this is our new channel please subscribe and share it

[@navdipsheladiya5777]

Thank you my friend!!

[@CSEngineeringGyan]

you are most welcome
please support us.

[@shashvatsaini5901]

❤thanks

[@CSEngineeringGyan]

you are most welcome

[@anithajhansi6589]

Nice video it's clean and clear explanation sir thank you so much for sir

[@CSEngineeringGyan]

Most welcome
please support us.

[@arpitamarathe008]

You are great👍💯

[@CSEngineeringGyan]

thank you
please support us.

[@pratikchetry4713]

Kal board ka final practical he or aaj dhek Raha huuu😅

[@CSEngineeringGyan]

all the best

[@darksdrums175]

Class 10 ka exam h helped a lot ty

[@CSEngineeringGyan]

thanks

[@etikaverma4336]

Very welled explanation sir bohot aache or easy language me aapne samjhaya thank you so much kya aap html ke uper bhi video upload kar sakte hai

[@uchiwa4433]

Thank you so much sir :)

[@CSEngineeringGyan]

Most welcome
please support us.

[@ଓଡ଼ିଆboyRUDRA]

Sir your video is 👍

[@CSEngineeringGyan]

Thanks and welcome
please support us.

[@CSEngineeringGyan]

www.youtube.com/@kailashjoshitutorials/featured
please support our new channel

[@pawanofficial1559]

Helped a lot😊

[@CSEngineeringGyan]

thank you

[@mehakayesha7050]

Dbms k mujha sab seekhna hai or mai try krongi

[@biswajitnayak2458]

Please sir need more tutorial 🙏🙏🙏

[@CSEngineeringGyan]

Please see our channel all tutorial related to SQL available
Thank you please support us.

[@CSEngineeringGyan]

ruclips.net/channel/UCEO7KQgRI6K6XsyTJlF79nw
please like share subscribe our new channel for latest technology like MongoDB,Python, BigData
thank you please support us.

[@KaushalKumar-nq2cx]

Very usefull

[@CSEngineeringGyan]

thank you so much
please support us.

[@reelspoint8822]

Helpful 👍

[@CSEngineeringGyan]

Glad to hear that
please support us

[@sachin__s9686]

1 day before skill test lab....😅😅😅

[@CSEngineeringGyan]

all the best

[@kumarbty1221]

Kya Bolu me🔥🧡😐😌 kal practical he ,,, aj maja aa gaya video dekke😋

[@CSEngineeringGyan]

thank you

[@SMHasan9]

Good info

[@CSEngineeringGyan]

Thanks

[@shaikalthamash3450]

how to delete (2 duplicate rows) in select * from student table

[@unknownmystry]

What to do in table if value is not available for particular columnn of row

[@sainagogoi6620]

Thank you❤

[@CSEngineeringGyan]

You're welcome 😊

[@manojgour8230]

Thankyou sir

[@CSEngineeringGyan]

you are most welcome

[@solidtricks9651]

Nice video

[@CSEngineeringGyan]

Thanks

[@SantoshSingh-sh4bo]

Thanks 🎉🎉

[@CSEngineeringGyan]

most welcome

[@rajkumarmaurya4863]

Very good 😊😊😊

[@CSEngineeringGyan]

thank you so much
please support us.

[@a___jgaming__9758]

Thank sir ❤️

[@CSEngineeringGyan]

most welcome
please support us.

[@rashisrivastava6691]

Helpful 🙂

[@CSEngineeringGyan]

Glad you think so!

[@ravipoojabansal3682]

It can be better

[@kiran4608]

Nice 👍

[@CSEngineeringGyan]

Thanks for the visit

[@EdushanYT]

Same day of practical exam...

[@CSEngineeringGyan]

all the best

[@vaishalibhammarkar4218]

yes mysql

[@Kavi_Tempest]

Sir doubt
create table student(varchar(50),rollnumber int(11),branch varchar(40));
I did exactly what you did still got error 1064 how to resolve this?

[@pickachu78]

you didn't specify the name of first column

[@moderndevils4000]

While performing insert command it showing 1 row affected but i insert multiple values it doesn't showing 2 rows affected else 3 rows affected..??

[@user-qp3me5dg4g]

Kal kisi ka it ka practical hai 10th board

[@cjcstudio6201]

Thanks bhai😊

[@CSEngineeringGyan]

most welcome
please support us.

[@cjcstudio6201]

@@CSEngineeringGyan sure😊

[@user-fg5og3mc8f]

tysm sir ;)

[@ashishbelwal1093]

For(i=0;i

[@CSEngineeringGyan]

Most welcome

[@CricketknowledgeX]

Thanku sir

[@CSEngineeringGyan]

most welcome
please support us.

[@CricketknowledgeX]

@@CSEngineeringGyan we will 👍

[@_.leo._1708]

Tq❤

[@CSEngineeringGyan]

Welcome 😊

[@SahilRajput-wg2ep]

appreciate it man :D

[@CSEngineeringGyan]

thank you so much