Tagged: mysql

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 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...

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...

How to create Database and tables in MySQL 0

MySQL Database and Tables

This tutorial demonstrates how to SQL statement that creates MySQL database tables in which  to store data. A simple database table look like this  : Creating a database : CREATE DATABASE  YOUR_DATABASE_NAME; In MySQL ...

How to use mysql through cmd 0

MySQL Command-line

MySQL comes with a command-line interface that let you run MySQL commands and SQL queries. While there are graphical tools like phpMyAdmin and MySQL Workbench, command line interface will come in handy when you...