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

[@prithvirajkopnar9394]

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

[@CSEngineeringGyan]

thank you so much

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

[@lavanyawasnik8719]

thanks sir esa awsome practical video pure yt mein nhi mila...👌👌👌👌

[@CSEngineeringGyan]

thanks

[@amatysharma4843]

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

[@CSEngineeringGyan]

you are most welcome
please support us.

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

[@devansh8191]

Thank You So Much Sir 🥰🥰❤️❤️. I have Watched many videos on UA-cam 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😊

[@abhinandanmaurya47]

Sir poori playlist kaha pr hai ....basics se practical of databse start krne ki?

[@CSEngineeringGyan]

please check our DBMS playlist

[@abhinandanmaurya47]

Listen one thing...on this 18 I have my external exams...can u please make video on the topics which I will tell u to make within 2 days?? So that it will be beneficial for me and for upcoming viewers??
Is it possible...if not make it down ...ok?

[@abhinandanmaurya47]

Send me your DBMS proper playlist....which include all topics related to clg syllabus..SQL and all

[@CSEngineeringGyan]

Will upload soon

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

[@rawatsd7153]

1 night before exam wale like kre

[@CSEngineeringGyan]

all the best

[@bhargabhaloi3080]

Kal kiska kiska DBMS lab ka exam haii 😂

[@CSEngineeringGyan]

all the best

[@mansiyadav5884]

Meraa

[@Mr_Rajput_rider]

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

[@Lk-916]

𝐌𝐞𝐫𝐚 𝐛𝐡𝐢

[@Asiya-p1z]

😢

[@Techbhaktt]

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

[@CSEngineeringGyan]

Most welcome 😊
please support us.

[@drshailendrakumarmishraast2805]

Sir hum sql ko mobile phone pe use kar sakte hai

[@MA-10]

Helped for my 12th board exam tomorrow 🤝

[@CSEngineeringGyan]

Great 👍

[@pokemonking1547]

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

[@CSEngineeringGyan]

Great 👍

[@DhillonShab-dj9dl]

Bahut achhe se karvate h sir aap

[@CSEngineeringGyan]

thank you
please support us.

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

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

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

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

[@a.k.classes]

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

[@CSEngineeringGyan]

ok next time
you are most welcome
please support us.

[@prof.ankitaagarwal5315]

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

[@CSEngineeringGyan]

Thank you, I will

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

[@yaminibawankar5956]

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

[@CSEngineeringGyan]

Most welcome

[@unknownmystry]

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

[@sameerpatil5923]

Teaching Level Very Simple
Thank You❤

[@CSEngineeringGyan]

You are most welcome

[@sameerpatil5923]

@@CSEngineeringGyan Keep It up💫

[@kusumlata9008]

Aap to computer wali mam se bhi acha batate hai

[@CSEngineeringGyan]

thanks

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

[@hellocharlie9169]

Dhanyavad bhai

[@CSEngineeringGyan]

you are most welcome

[@aarontirkey1505]

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

[@CSEngineeringGyan]

You're most 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

[@dxtr1ty]

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

[@abhishekvathare7846]

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

[@CSEngineeringGyan]

Thanks a lot

[@sultanahaifaparvin155]

Thanks for making me understand

[@CSEngineeringGyan]

you are most welcome

[@abhinandanmaurya47]

Iska poora playlist k link do

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

[@anithajhansi6589]

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

[@CSEngineeringGyan]

Most welcome
please support us.

[@Murtuzafani5782]

How to move cursor up down front back in mysql.....?? Please reply

[@CSEngineeringGyan]

using up down left right key in keyboard

[@darksdrums175]

Class 10 ka exam h helped a lot ty

[@CSEngineeringGyan]

thanks

[@topperexam1826]

Sir how print it in a practical exam

[@akankshasharma1178]

Sir, i want to ask you that can we change field (name, rollnumber, branch) in upper side. I mean table me opper likha ho ye sab side ki bjaye
N sir, mene ek student ki values add ki thi , to kya baad me add krne k liye kya krna hoga

[@rajeshmodem6097]

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

[@CSEngineeringGyan]

You are welcome
please support us.

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

[@nainat.255]

Sir please clarify our one doubt?
Sir we want do masters in website development but we don't know which course we will do please help sir
Thank you

[@CSEngineeringGyan]

First you learn html,css,javascript then php

[@CSEngineeringGyan]

And first you lear web designing course

[@CSEngineeringGyan]

ua-cam.com/channels/EO7KQgRI6K6XsyTJlF79nw.html
please like share subscribe our new channel for latest technology like MongoDB,Python, BigData
thank you please support us.

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

[@DEF_ABHI21]

thanks sir jiiiii

[@CSEngineeringGyan]

you are most welcome
please support us.

[@रामप्रकाशरासवानी]

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

[@CSEngineeringGyan]

thank you so much
please support us.

[@CSEngineeringGyan]

ua-cam.com/channels/EO7KQgRI6K6XsyTJlF79nw.html
this is our new channel please subscribe and share it

[@bisalranjanswain2434]

The way of explanation is just excellent 👍

[@CSEngineeringGyan]

Thanks a lot 😊

[@pavankulal9980]

Thank you Bhai, it was very helpful

[@CSEngineeringGyan]

Always welcome
please support us.

[@mehakayesha7050]

Dbms k mujha sab seekhna hai or mai try krongi

[@yuvigod6699]

Thanks a lot sir

[@CSEngineeringGyan]

you are most welcome
please support us.

[@neejanand771]

Thank you bhaiya meri problem solve karne ke liye

[@CSEngineeringGyan]

most welcome

[@pramodchandelpkc]

Thanks for Sharing

[@CSEngineeringGyan]

most welcome

[@ceramicpottery5983]

The table looks more real with shapes option in paint 🎨

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

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

[@rameshagrahari-p8j]

Thanks for this video.

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

[@abhinavgiriproperties]

very good mic sir

[@CSEngineeringGyan]

thanks

[@ishasethkhushi1774]

Sir would u plzz make a vidoe on daa subject

[@CSEngineeringGyan]

ok as soon as possible

[@kumarbty1221]

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

[@CSEngineeringGyan]

thank you

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

[@HP__PREM]

bhayia isme phlele wale video ka link mention kr dete

[@CSEngineeringGyan]

ok

[@KaushalKumar-nq2cx]

Very usefull

[@CSEngineeringGyan]

thank you so much
please support us.

[@Proud_743]

Thank you so much sir ji 🙏🙏😊

[@CSEngineeringGyan]

you are 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

[@shaikalthamash3450]

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

[@Riyayadav_76]

Thank you Sir 😊

[@CSEngineeringGyan]

Most welcome

[@Utkarsh-Shukla]

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

[@CSEngineeringGyan]

all the best

[@Utkarsh-Shukla]

@@CSEngineeringGyan thanks 😊

[@shadowgaming6180]

Thank you very much sir.

[@CSEngineeringGyan]

Most welcome

[@rahultandale8561]

Thank you for your guidance 🤠

[@CSEngineeringGyan]

You are so welcome

[@AllEdits-bo3pi]

Thank you so much sir 💗😊

[@CSEngineeringGyan]

Most welcome 😊
please support us.

[@DhruvAgnihotri-ih7vl]

thank you

[@CSEngineeringGyan]

You're welcome

[@mohdaarish2672]

Sir Select commander mai star(*) kyu lgaya h

[@CSEngineeringGyan]

astrick bolte hai ise iske through complete column select hote hai

[@l.o.stlifeofstudents6071]

Thank you sir for this helpful video👍🙏

[@CSEngineeringGyan]

Most welcome
please support us.

[@Kuldeep-t6q]

Nice sir

[@CSEngineeringGyan]

Thanks and welcome

[@arpitamarathe008]

You are great👍💯

[@CSEngineeringGyan]

thank you
please support us.

[@rinkle7879]

bhaiya mein 5 rows baanaya tha par jab mein command diya select * from student tho mere ko sirf 4 rows hi show hue

[@CSEngineeringGyan]

ek bar fhir check kare all row check karega

[@rinkle7879]

@@CSEngineeringGyan ok, Thank you soo much

[@ravitapandey1364]

Thanks for explaining

[@CSEngineeringGyan]

You are most welcome

[@SMHasan9]

Good info

[@CSEngineeringGyan]

Thanks

[@Mammajiprincess]

Thank you so much sir...very understanding video

[@CSEngineeringGyan]

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

[@-jess-3784]

Is it sql 2019?

[@CSEngineeringGyan]

yes

[@akshaynaidu2094]

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

[@CSEngineeringGyan]

Thanks and welcome

[@nalajalabhuvana8788]

can u send me the installation link of sql

[@solidtricks9651]

Nice video

[@CSEngineeringGyan]

Thanks

[@uchiwa4433]

Thank you so much sir :)

[@CSEngineeringGyan]

Most welcome
please support us.

[@SantoshSingh-sh4bo]

Thanks 🎉🎉

[@CSEngineeringGyan]

most welcome

[@deepak_arya44]

Very helpful video 👍

[@CSEngineeringGyan]

Glad it was helpful!

[@ChandanChandan-ft1ic]

sir if i give int it is not taking what to do sir

[@CSEngineeringGyan]

varchar is use

[@ChandanChandan-ft1ic]

@@CSEngineeringGyan sir actually for integers values I gave both num and Int both are not working what to do sir

[@navdipsheladiya5777]

Thank you my friend!!

[@CSEngineeringGyan]

you are most welcome
please support us.

[@durgeshshekhawat4222]

Aaj hi DBMS ki exam he bhai😅

[@CSEngineeringGyan]

all the best

[@D_koyo]

Thanks bro ...

[@CSEngineeringGyan]

Welcome

[@ronak6458]

how can i download sql can you give link plz

[@CSEngineeringGyan]

ua-cam.com/video/zGrEnkqWdP0/v-deo.html

[@ronak6458]

Thx❤️

[@Inini7X11]

how can i download complier in my laptop

[@20plusbgmi]

bhai date dalta hu to error aata hai

[@Toxictoad-x3f]

tysm sir ;)

[@shashvatsaini5901]

❤thanks

[@CSEngineeringGyan]

you are most welcome

[@kaurritu5149]

Sir plz improve the sound quality 🙏 , as u make very useful vedio❤

[@CSEngineeringGyan]

I will try my best

[@manojgour8230]

Thankyou sir

[@CSEngineeringGyan]

you are most welcome