MySQL - Data Manipulation Statements

MySQL CALL Statement

This statement is used to call the stored procedure.

MySQL DELETE Statement

This statement is use to remove records from a table.

MySQL DO Statement

This statement is used execute MySQL statement.

MySQL INSERT Statement

This statement is used to insert records into a table.

MySQL LOAD DATA Statement

This statement loads the contents of a file into a table.

MySQL LOAD XML Statement

This statement is used to load the contents of an XML file into a table.

MySQL REPLACE Statement

This statement inserts a new record into a table. if you try to insert a new column with duplicate value for the column with UNIQUE or PRIMARY KEY constraints the old record will be completely replaced by the new record.

MySQL SELECT Statement

This statement is used to retrieve rows from MySQL tables.

MySQL Subquries Statement

A subquery is a query with in a query.

MySQL TABLE Statement

This statement is used to retrieve the rows and columns of a specified table.

MySQL UPDATE Statement

This statement is used to update one or more records of an existing table.

MySQL VALUES Statement

This statement is used to return a set of rows as a table.

MySQL WITH Statement

This statement is used to create common table expressions.