- MySQL Join
The INNER JOIN is used to query join multiple tables together. The join condition must match column values from both tables. Basically you are getting what both tables have in common. Here we are joining the customer table and the address table to show the customer address details. For each row in…
- MySQL Order By
The ORDER BY clause is used to sort the result set which is not sorted by default. You can sort the result set by one or multiple columns and either in the ascending or descending order. ASC – sort in ascending orderDESC – sort in descending order* by default if [ASC|DESC] is omitted then […]
- MySQL Between
The BETWEEN is used in the WHERE clause to check if a value is in a range. Here is an example of BETWEEN and AND. We are querying customers that have sales rep with id between 1 and 7. BETWEEN can also be done by using >= and <=. Here is an example of […]
- MySQL ISNULL
IS NULL is used in the WHERE clause to check if a value is NULL or not. IS NULL in action.
- MySQL Limit
The LIMIT clause, as you might guess, is used to limit the number of rows returned in the result set. It has two parameters or arguments. The first parameter is offset which tells mysql how many rows to skip before starting to retrieve. The second parameter is count which tells mysql how many rows…