MySQL Examples and Tutorials
In this tutorial, we will take a look at the MySQL IS NULL condition. Suppose you are conducting a survey in your neighborhood and you hand out a small questionnaire to everyone in the area. After a day or two, you receive the questionnaires back and you notice that some people have not answered a …
MySQL IS NULL Condition – How-to Find And Replace NULL Vales in a Database? Read More »
In this quick tutorial, we’ll take a look at the MySQL NOT operator. Suppose you are a teacher and you want a list of students who were not present for all 100 days in a term. In other words, the condition of students present for 100 days should NOT be satisfied, and the resulting output …
In this tutorial, we’ll work on the MySQL OR operator. Suppose you are a teacher and you want to find out students who scored above 90 in their Maths or Science exams to be considered for the position of class monitor. So, in short, if a student scores above 90 in either Maths or Science, …
In this tutorial, we’ll be talking about the MySQL AND Operator. Suppose you are playing a video game and you pass a level only if you earn $50,000 and complete 2 missions. So, the logic is that you have two conditions you need to satisfy to pass the level. What if you encounter a similar …
MySQL AND Operator – Execute Multiple Conditions in MySQL Read More »
MySQL DESCRIBE query is used to describe a table. A short form of the DESCRIBE command is DESC. The DESCRIBE command is used to gain information about the table. It displays column names and the data type of every column along with the associated constraints. Suppose you are taking a walk in the city and …
MySQL DESCRIBE – Get Detailed Information on Database Tables Read More »
The MySQL NOT IN Operator does the exact opposite of the MySQL IN Operator. The NOT IN operator checks if a value is not present in a set of values and returns those values. Suppose you are a boarding school administrator and you want to know which of your students are not from Pune or …
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 »