Mysql

MySQL NULL Values

We have seen the SQL SELECT command along with the WHERE caluse to fetch data from a MySQL table, but…

MySQL LIMIT

The MySQL LIMIT clause is used to narrow or limit, a result set to the specified number of rows. The…

MySQL LIKE

The comparison operators discussed so far have compared one value, exactly to one other value. Such precision may not always…

MySQL Between Operator

In order to select data that is within a range of values, the BETWEEN operator is used. The BETWEEN operator…

MySQL Order By

The data return by a SELECT query can be sorted into a specified order using ORDER BY clause. Syntax: SELECT…

MySQL AND, OR, IN, NOT IN

AND, OR, In, NOT In these all are called logical operators: AND(&&) : The AND operator allows creating an SQL…

MySQL Where Clause

MySQL SELECT DISTINCT