MySQLCode - Page 32 of 32 - MySQL Tutorials and Examples

MySQL Select Statement – Fetching Data from MySQL Databases

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 Clause – How to Display Unique Values from a MySQL Database?

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 »