Tagged: mysql tutorials

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 Query 0

MySQL Select Query

A SELECT query can return the data from multiple columns by including the required column names as a comma-separated list in the query. The syntax to get multiple column data looks like this: If...

Inserting data in MySql 0

MySQL Insert Into

Data can be inserted in to an existing database table with an INSERT INTO query that first specified the table name. The SQL VALUES  keyword then specifies the actual data to be inserted as comma-separated...

Altering tables in mysql 0

MySQL Altering tables

The format of an existing database table can be changed with an ALTER TABLE query . This query can make a single alteration or specify as number of alterations as comma-separated list. In the...

Column Modifiers in MYSQL 0

MySQL Column Modifiers

Modifiers can optionally be used to further control column content. NOT NULL UNIQUE AUTO_INCREMENT DEFAULT PRIMARY_KEY NOT NULL Insists that each record must include a data value in this column. This allows an empty...