|
|
Statement Syntax (Mysql)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_definition BY ... row_count Example: DO HANDLER INSERT LOAD DATA INFILE REPLACE SELECT Subquery TRUNCATE UPDATE External links MySQL Manual: Chapter 13. SQL Statement Syntax
|
 |