MySQL Examples and Tutorials
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 »