In this post, you will see how to use update and delete commands in MySQL. As the name suggests they are used to update or delete the data in table. But there are some important thing we need to keep in mind while using those commands.
In this post, you will learn about WHERE clause in MySql command line. Where clause is used to fetch data with some specific conditions. If that specific condition is met, then it return the data to print.
In this post, you will see how to fetch data using select keyword. Also, you will see different options to use with select statement. You will see how to use distinct keyword with the select statement.