MySQL : Statements

Context of the notion in the technology: Document / Topc: MySQL
Related Keywords: My SQL Statements
Help URL: http://dev.mysql.com/doc/refman/4.1/en/sql-syntax.html

Items Related to Statements

Data Types (Data Types)
Functions
Statements
Server System Variables (Server System Variables)
Server Status Variables (Server Status Variables)
Dynamic System Variables (Dynamic System Variables)

Inner Elements of Statements

Statements contains following items:

ALTER DATABASE (ALTER DATABASE)
ALTER TABLE (ALTER TABLE)
CREATE DATABASE (CREATE DATABASE)
CREATE INDEX (CREATE INDEX)
CREATE TABLE (CREATE TABLE)
DROP DATABASE (DROP DATABASE)
DROP INDEX (DROP INDEX)
DROP TABLE (DROP TABLE)
RENAME TABLE (RENAME TABLE)
DELETE
DO
HANDLER
INSERT
LOAD DATA INFILE (LOAD DATA INFILE)
REPLACE
SELECT
JOIN
UNION
Subqueries
TRUNCATE
UPDATE
DESCRIBE
USE
START TRANSACTION (START TRANSACTION)
COMMIT
ROLLBACK
SAVEPOINT
LOCK TABLES (LOCK TABLES)
UNLOCK TABLES (UNLOCK TABLES)
SET TRANSACTION (SET TRANSACTION)
DROP USER (DROP USER)
GRANT
REVOKE
SET PASSWORD (SET PASSWORD)
ANALYZE TABLE (ANALYZE TABLE)
BACKUP TABLE (BACKUP TABLE)
CHECK TABLE (CHECK TABLE)
CHECKSUM TABLE (CHECKSUM TABLE)
OPTIMIZE TABLE (OPTIMIZE TABLE)
REPAIR TABLE (REPAIR TABLE)
RESTORE TABLE (RESTORE TABLE)
SET
CACHE INDEX (CACHE INDEX)
FLUSH
KILL
LOAD INDEX INTO CACHE (LOAD INDEX INTO CACHE)
RESET
EXECUTE
PREPARE
COLLATE
SHOW CHARACTER SET (SHOW CHARACTER SET)
SHOW COLLATION (SHOW COLLATION)
SHOW COLUMNS (SHOW COLUMNS)
SHOW CREATE DATABASE (SHOW CREATE DATABASE)
SHOW CREATE TABLE (SHOW CREATE TABLE)
SHOW DATABASES (SHOW DATABASES)
SHOW ENGINE (SHOW ENGINE)
SHOW ENGINES (SHOW ENGINES)
SHOW ERRORS (SHOW ERRORS)
SHOW GRANTS (SHOW GRANTS)
SHOW INDEX (SHOW INDEX)
SHOW INNODB STATUS (SHOW INNODB STATUS)
SHOW LOGS (SHOW LOGS)
SHOW OPEN TABLES (SHOW OPEN TABLES)
SHOW PRIVILEGES (SHOW PRIVILEGES)
SHOW PROCESSLIST (SHOW PROCESSLIST)
SHOW STATUS (SHOW STATUS)
SHOW TABLE STATUS (SHOW TABLE STATUS)
SHOW TABLES (SHOW TABLES)
SHOW VARIABLES (SHOW VARIABLES)
SHOW WARNINGS (SHOW WARNINGS)
PURGE MASTER LOGS (PURGE MASTER LOGS)
RESET MASTER (RESET MASTER)
SET SQL_LOG_BIN (SET SQL LOG BIN)
SHOW BINLOG EVENTS (SHOW BINLOG EVENTS)
SHOW BINARY LOGS (SHOW BINARY LOGS)
SHOW MASTER STATUS (SHOW MASTER STATUS)
SHOW SLAVE HOSTS (SHOW SLAVE HOSTS)
CHANGE MASTER TO (CHANGE MASTER TO)
LOAD DATA FROM MASTER (LOAD DATA FROM MASTER)
LOAD TABLE tbl_name (LOAD TABLE em class replaceable code tbl name)
MASTER_POS_WAIT() (MASTER POS WAIT )
RESET SLAVE (RESET SLAVE)
SET GLOBAL SQL_SLAVE_SKIP_COUNTER (SET GLOBAL SQL SLAVE SKIP COUNTER)
SHOW SLAVE STATUS (SHOW SLAVE STATUS)
START SLAVE (START SLAVE)
STOP SLAVE (STOP SLAVE)
CREATE FUNCTION (CREATE FUNCTION)
DROP FUNCTION (DROP FUNCTION)

MySQL is a multithreaded, multi-user, SQL Database Management System (DBMS) with an estimated six million installations. MySQL AB makes MySQL available as free software under the GNU General Public License (GPL), but they also dual-license it under traditional proprietary licensing arrangements for cases where the intended use is incompatible with the GPL. -- wikipedia.org

Home