Suppose you are a boarding school administrator and you want to know which of your students are from Pune, Nagpur, and Mumbai from an SQL table. You can always use multiple OR operators but there is another, more effective way. We are looking at students in Pune, Nagpur, and Mumbai. And MySQL, like the beautiful …
The MySQL WHERE Clause is a powerful and widely used keyword that allows you to set a conditional filter on your queries. The WHERE clause can be used on the SELECT, UPDATE, and DELETE statements. Suppose you have a long guest list for an international conference and you want to see only the guests from …
MySQL WHERE Clause – Display MySQL Table Data Conditionally Read More »
The MySQL SELECT statement forms a part of the Data Query Language (DQL) in SQL, which deals with fetching data. Suppose you are putting on a science exhibition. To decide upon which exhibits (or projects) to put on display in the exhibition, you would first select a project and then put it for display. Similarly, …
MySQL Select Statement – Fetching Data from MySQL Databases Read More »
MySQL DISTINCT helps you find out the distinct or unique values from a table. This is very helpful as it omits the duplicate values from the result-set and returns only the distinct values. Suppose you are at an international conference. You have been informed that the conference has 100 guests. There are 20 guests each …
MySQL DISTINCT Clause – How to Display Unique Values from a MySQL Database? Read More »