Category: Mysql

mysql null values 0

MySQL NULL Values

We have seen the SQL SELECT command along with the WHERE caluse to fetch data from a MySQL table, but when we try to give a condition, which compares the field or column value...

MySQL Limit Clause 0

MySQL LIMIT

The MySQL LIMIT clause is used to narrow or limit, a result set to the specified number of rows. The LIMIT clause accepts one or two arguments, one is offset and another one is...

mysql-between-operator 0

MySQL Between Operator

In order to select data that is within a range of values, the BETWEEN operator is used. The BETWEEN operator allows the selection of rows that contain values with a specified lower and upper...

MySQL Order By 0

MySQL Order By

The data return by a SELECT query can be sorted into a specified order using ORDER BY clause. Syntax: SELECT column-name FROM table-name ORDER BY column-name; When the ORDER BY keywords are followed by...

MySQL AND, OR, IN, NOT IN 0

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 statement based on two or more conditions being met. It can be used in...

MySQL Where Clause 0

MySQL Where Clause

A WHERE Clause is an SQL query to apply a filter on the rows retrieved. When a WHERE Clause is added to MySQL query, the MySQL engine compares each record in the table with...

MySQL SELECT DISTINCT 0

MySQL SELECT DISTINCT

A table could hold duplicate rows. In such a case, to view only unique rows the distinct clause can be used. The DISTINCT clause allows removing duplicates from the result set. The DISTINCT clause can...