MySQL Tutorial for Beginners – 3 – Select data from table and Update data of the table

Video is ready, Click Here to View ×


Hello Friends,
In today’s video, we will get to learn about selecting data of our choice from a given database table and how to update data of the given database table.

Please subscribe this channel, so that you will not miss any videos in future:

SQL Commands used for selection and updation of data for database table:
=================================================================
select * from employees;
select name from employees;
select * from employees where name = ‘krishna’;
select * from employees where hometown = ‘kochi’;
select * from employees where nri = ‘no’;
select * from employees where nri = ‘no’ order by id desc;
update employees set hometown = ‘delhi’ where name = ‘jennifer’;
update employees set hometown = ‘Aurangabad’;
=================================================================

XAMPP Download link for All OSes:

MySQL Tutorial for Beginners – 1 – Creating a Database and…

sql tutorials for beginners

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.