INSERT, JOIN, LOAD, DELETE, SHOW, and etc...
-
SELECT
Syntax SELECT [ALL | DISTINCT | DISTINCTROW] [HIGH_PRIORITY] [STRAIGHT_JOIN] -
JOIN
Description MySQL supports the following JOIN syntaxes for the table_refere... -
UNION
Syntax SELECT ... UNION [ALL | DISTINCT] SELECT ... [UNION [ALL | DISTINCT]... -
HANDLER
The HANDLER statements gives you direct access to reading rows from the sto... -
INSERT commands
Articles on INSERT. -
REPLACE
Syntax: REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [(col_name,...... -
UPDATE
Syntax Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET col_name -
DELETE
Syntax Single-table syntax: DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl... -
TRUNCATE TABLE
Syntax TRUNCATE [TABLE] tbl_nameDescription TRUNCATE TABLE empties a table ... -
LOAD data into tables or index
Loading data quickly into MariaDB -
CALL
Syntax: CALL sp_name([parameter[,...]]) CALL sp_name[()]Description: The CA... -
DO
Syntax: DO expr [, expr] ...Description: DO executes the expressions but d... -
DUAL
Description: You are allowed to specify DUAL as a dummy table name in situa... -
IGNORE
The IGNORE option tells the server to ignore some common errors. IGNORE can...
