4. What is Data Manipulation Language in SQL? Using SELECT, INSERT, UPDATE, DELETE commands in MySQL

Welcome to Everything Computerised. I'm CA and in this video I'll be going to explain you the Data Manipulation Language (DML) in detail and the different commands present in it.
There are 4 commands in DML. These are SELECT, INSERT, UPDATE and DELETE. I'll explain everything in detail, so watch this video till end.
Important links:-
► Install MySQL :- • How to Install the lat...
► Previous Video (#3. SQL Data Types):- • 3. What are SQL Data T...
► Next Video (Problem Solving #1) :- • How to create a table ...
► Link to SQL Playlist :- bit.ly/3uv6r29
► What is DDL? :- • 2. What is Data Defini...
► How to use internet on PC :- • How to use internet on...

[@avadhrakholiya8269]

Your explanation dragged my thumb to the subscribe button 👍🏼

[@EverythingComputerized]

Oh.. that's great🤭. Thank you so much for the compliment😊😊😊

[@nikhilseth0017]

RUclips par mujhe pahla aisa video mila jo mujhe SQL command ko samjha paya. WELDONE👍

[@EverythingComputerized]

Bahut bahut shukriya apka❤❤

[@pabloemilioescobargaviria297]

Bro deserves .uch more subscribers. You are a saviour. Bro provided content that many big YT channels were unable to provide in a such a simple yet affective manner

[@EverythingComputerized]

Thanks a ton! 😊

[@aggreez]

This Explanation is so precise and clear...I finally understood how this works. Amazing Work!! Thank you so much for this...😊😊

[@EverythingComputerized]

😊

[@JBS439]

This is the best video I have watched this year. Thanks so much .you are the best

[@EverythingComputerized]

Glad it helped! ❤✌

[@TarunReddy-np8yz]

It's pretty simple and easy explanation.
Thank you. 🙏

[@EverythingComputerized]

😄❤

[@swathireddy1470]

Superb explanation no words to say

[@allaboutit-4023]

I don't have words to appreciate you... May God bless you!! Touch wood 🥰

[@EverythingComputerized]

Thank you for constant support!
❤💝

[@armanali.shaikh7799]

Thank u so much Bro , because ur explaination is very good with run..!

[@EverythingComputerized]

My pleasure ❤

[@poornachandrika6718]

Very happy and excited to learn from your channel... Tq very much bro😊

[@EverythingComputerized]

Thank you!

[@aroojsabir5475]

Your explanation is on another level bro First time i like a vedio on RUclips
Keep it up👍

[@EverythingComputerized]

Thats so good! Thank you❤😊

[@erinahayyath1964]

Thankyou.... keep growing

[@sanketjaisingpure7028]

Thanks a lot man your way of teaching is excellent

[@EverythingComputerized]

Thanks buddy!❤

[@Benedict_Miriti]

Quite informative! Not all heroes wear capes.

[@EverythingComputerized]

Thank you so much❤️🫂

[@colinfu9564]

Thank you very much for this man. ❤

[@EverythingComputerized]

My pleasure!

[@mcoyibanez9805]

Thank you, ❤

[@MutungaKasamu]

Well explained, thanks

[@EverythingComputerized]

Thnku so much...it means a lot😊

[@RishiSharma-ti4bt]

Best explanation with best example amazing brother!!

[@EverythingComputerized]

Thank you 💓

[@neggas-]

Good thing i found your video , today is my exam and youve earned me 5 marks 💖👋

[@EverythingComputerized]

Oh.. that's great buddy... I'm happy to know that my videos are helpful... anyways, good luck for your exams💪💗

[@kshitijsalunke498]

Hahaha good

[@user-rn7td9qz5n]

TBH this is a very good explanation no cap 😊🎉😊

[@EverythingComputerized]

Glad it was helpful!

[@mzalendoentartainment32]

Thanks tooo, because you concept is very undeserstandable well

[@EverythingComputerized]

Thank uu🙌

[@technicalfacts8002]

Bahut bahut dhanyvad sir love you 🙏🙏🙏

[@EverythingComputerized]

😊❤❤❤❤

[@robertmaina4807]

Very well explained...Thank you.

[@EverythingComputerized]

Glad it was helpful!

[@samiyakhan3049]

Your explanation is superb yar actually I generally don't understand the syntax and commands but btw with ur explanation it is possible to to understand it very easily
Thanks 👍👍💗💗👍👍👍👍👍

[@EverythingComputerized]

I'm happy it helped you!
Thank you!

[@balakrishnabi7450]

thanks for giving nice info with awesome presentstion

[@EverythingComputerized]

❤👍

[@vikramnishad3664]

Really Nice Explanation 👍👌
Thanks
Tommarow My Pre-board ( Computer Sub)

[@EverythingComputerized]

Hope your exams went well.
All the best for your final. ❤🙌🙂

[@vinod00012]

Very much informative

[@EverythingComputerized]

🙂✌

[@aishasamem9017]

Thank you very much

[@EverythingComputerized]

You are welcome

[@madhusureshbabu7440]

Yes ur's explanation is soo good. Tq u bro..

[@EverythingComputerized]

Most welcome! 😊

[@delawersaif6263]

Thanks a lot bro, nice explain

[@EverythingComputerized]

☺

[@techyboy1228]

thanks bro nice explain

[@EverythingComputerized]

Welcome.. my pleasure☺

[@mehwishuiux]

You are a lifesaver 🤧🤧🤧🤧🤧✌️✌️💜💜💜

[@EverythingComputerized]

☺☺

[@lynnettelynch5920]

You've gain a new follower

[@EverythingComputerized]

😄❤❤

[@user-ux9kl7kk4x]

like ur explanation, u make it simple and clear😍👊🏻🔥,i feel like i could top my class in tmr exam

[@EverythingComputerized]

Glad to hear that buddy!😄

[@gundalamahesh3971]

Simply supper 👍

[@EverythingComputerized]

Thank you very much

[@TechReviewer07]

May God bless you for helping me for us.

[@EverythingComputerized]

✌🤗

[@sandeephubballi4127]

its very usefull❤

[@EverythingComputerized]

🙂

[@yasirjune69]

Great job.

[@EverythingComputerized]

🙌🙂

[@pistolerointergalactico9019]

TY

[@pawansasane166]

Thanks .. Subscribed

[@EverythingComputerized]

🙂😊

[@tituswilliamsunil8617]

Very helpfull. ...

[@EverythingComputerized]

Glad it was helpful!

[@chmsrkrishna3135]

Good explanation broooo

[@EverythingComputerized]

Thnku buddy❤😃

[@foody_number_one]

Thank you bro ❤️

[@EverythingComputerized]

😄❤

[@VNFilmography]

Thank you

[@EverythingComputerized]

✌

[@abhishekhbhuyan3970]

Thank you 😊

[@EverythingComputerized]

😄

[@techno_treat7028]

thank you

[@EverythingComputerized]

You're welcome

[@padmapriyaviswanathan4029]

Super explanation

[@EverythingComputerized]

Loved to hear that🤭❤

[@padmapriyaviswanathan4029]

@@EverythingComputerized 🙂🙂🙂

[@EverythingComputerized]

🤗

[@jyothikakukkamalla2831]

Tq so much sir , u r explanation is very good , viewers can esy to understand 🙏🙏🙏, tq sir sir pls applode all the DBMS lessons pls

[@EverythingComputerized]

Thank you so much for support. I'll surely upload all the videos one by one. ❤❤❤

[@jyothikakukkamalla2831]

@@EverythingComputerized tq sir

[@Meku487]

Thanku👍

[@EverythingComputerized]

😄✌

[@madhusureshbabu7440]

Super bro

[@EverythingComputerized]

😊😇

[@xolanitarence8853]

This is so helpful can I get more advanced videos for Data manipulation

[@EverythingComputerized]

I'll try to plan them!

[@animoki9292]

Good and good 👍

[@EverythingComputerized]

❤ and ❤

[@georgeswilnic555]

maybe 3 to 4 weeks classes would help a lot thanks.

[@EverythingComputerized]

🙂

[@yurisucupira]

👏🏻👏🏻👏🏻

[@onkarshinde795]

👍👍

[@rowenahinumla6647]

Very helpful, sir, may I ask the link for the hand out about ds discussion

[@EverythingComputerized]

U can contact on insta

[@skygamer5684]

✌✌

[@eyoelshimeles8700]

cool

[@EverythingComputerized]

😀

[@siddharthjha_18]

instead of SELECT * FROM table_name;
you can use DESC table_name; or just desc table_name

[@EverythingComputerized]

DESC tableName; is used to describe a table. It lists out the columns and its characteristics like data type, keys, etc.
If you want to view rows, then you have to use SELECT only.
Hope this helps. 🙂

[@hyperphenomenal4360]

thank you very much,
while coding i got one message in SQL, it showed some number of warnings, it came like (no.of warnings:2), what does it mean, any idea??

[@EverythingComputerized]

That's a thing you don't need to worry about when you are learning sql..
Warnings occurs when there's a better way to do something...
For example, its better to define size in int data type, which usually we dont do when we are to learn sql..
But when we master it and use it for actual production stuff, then we consider that..
So, u can just ignore it.. softwares get updated very often, thereby obsoleting old stuff and adding new ones.. and as a student, we dont actually have to worry about minor things, until there's a considerable noticeable update..
But yes, if we are to use Mysql in our software project as a tool, then we have to look into every minor and major change!
Hope you get a clear view of this now!
🙂

[@hyperphenomenal4360]

@@EverythingComputerized got it crystal clear thank you for your time!!!

[@EverythingComputerized]

❤

[@Ciencia-Vida]

Thanks for the info but I am a little confused because the INSERT command is present in the DQL(Data Query Language)

[@EverythingComputerized]

These are just a way to classify commands. Not a big deal though.

[@georgeswilnic555]

Hello ! how are you doing? i'd like to take some classes from you. how can i get your information please.

[@EverythingComputerized]

Its nice to hear that! But as of now I dont conduct classes! For any information in future, I'll update it on my channel!

[@AbhishekSharma-tc7zr]

Link of video for select command in detail i havnt find in list

[@EverythingComputerized]

Actually, I made only till TCL.
I'll make remaining videos soon.
Thank you so much for being with us.

[@Anj9]

Select command with clauses I can't find it

[@EverythingComputerized]

I haven't posted it yet. I'll be posting soon. ❤

[@igic9663]

Can you please tell me how to source SQL file in MySQL 8?

[@EverythingComputerized]

Are u asking about importing an existing sql database file?

[@igic9663]

@@EverythingComputerized yes please

[@EverythingComputerized]

Hope this helps
dev.mysql.com/doc/refman/8.0/en/mysql-batch-commands.html

[@abderahimB]

If i want to select only the contrys that have the population grater thene 30M

[@rushaanabdi8000]

🥰🥰🥰

[@EverythingComputerized]

😇

[@abdheshkumar249]

Quotations mark sirf text ke liye lagega

[@EverythingComputerized]

Yes.. I've explained in the vdo..
Infact, only single quotations are supported in most DBMS.
Example - 'Everything Computerized'