Stored Procedures and Functions – Mysql Tutorials

Stored Routines (Procedures and Functions) are supported in version MySQL 5.0. Stored Procedure is a set of statements, which allow ease and flexibility for a programmer because stored procedure is easy to execute than reissuing the number of individual SQL statements. Stored procedure can call another stored procedure also. Stored Procedure can very useful where [...]

Views – mysql tutorials

VIEW is a virtual table, which acts like a table but actually it contains no data. That is based on the result set of a SELECT statement. A VIEW consists rows and columns from one or more than one tables. A VIEW is a query that’s stored as an object. A VIEW is nothing more [...]

Joins – Mysql Tutorials

Sometimes you required the data from more than one table. When you select the data from more than one table this is known as Joining. A join is a SQL query that is used to select the data from more than one table or views. When you define multiple tables or views in the FROM [...]

Data Manipulation Statements – Mysql Tutorials

Data Manipulation Statement is used to retrieve, insert, update and delete the records in a database. All database users will use these commands during routine operation of the database. In this section we are describing the following Data Manipulation Statements :

Select Statement
Insert Statement
Update Statement
Delete Statement

SELECT Statement
The SELECT statement is used to retrieve a result set [...]

Data Definition Statement – Mysql Tutorials

In this section we will describe you the syntax of most of the Data Definition statements supported by MySQL. These statements are given below :
Creating a Database
For creating a database the command syntax :
CREATE DATABASE [IF NOT EXISTS] <db_name>
By the command CREATE DATABASE we can create the database with the given name. But using this [...]