Statement syntax (MySQL) - Definition

Statement syntax for MySQL refers to what the different operations are (delete, add, etc.), how they function, and how to properly write them (syntax) in order for the program to run.

Syntax is important in any computer language. This is so since a computer is expecting the correct input, and if it is not structured correctly the computer does not know what to do. This article will explain the different oprations in the MySQL database program, and their proper syntax in these categories:

Data manipulation statements

DELETE

The DELETE command removes data fields from a table.

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name

      [WHERE where_definition]
      [ORDER BY ...]
      [LIMIT row_count]

Example:

DO

HANDLER

INSERT

LOAD DATA INFILE

REPLACE

SELECT

Subquery

TRUNCATE

UPDATE

External links

MySQL Manual: Chapter 13. SQL Statement Syntax (http://dev.mysql.com/doc/mysql/en/sql-syntax.html)