MySQL DATA Manipulate Statements

#	Statement	Description
1	CALL	invokes a stored procedure
2	Delete	Deletes rows from a table.
3	DO	Executes an expression without return any results
4	HANDLER	Provides direct access to table storage engine interfaces
5	INSERT	Inserts a new row into a existing table
6	LOAD DATA INFILE	reads rows from a text file and insert into a table at a very high speed
7	LOAD XML	reads data from an XML file and insert into a table
8	REPLACE	REPLACE works extactly like INSERT
9	SELECT	Gets or retrieves rows from one or more tables
10	Subquery as Scalar Operand	Subquery return a single value
11	Subquery Comparisons	Uses comparison operators with Subquery
12	Subquery with ANY	Uses ANY Keyword with subquery
13	Subquery with IN	Uses IN keyword with subquery
14	Subquery with SOME	Uses SOME keyword with subquery
15	Subquery with ALL	Uses ALL keyword with subquery
16	Subquery with EXISTS	Uses EXISTS keyword with subquery
17	Subquery with Row Subquery	Subquery can return a signle row and also can return more than one column value.
18	Correlated Subquery	A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query
19	Optimizing Subquery	Optimizing subquery for performance
20	Subquery VS JOIN	Rewrites Subquery with JOIN statement
21	Update	Updates columns of an existing rows in a table.