Types of SQL Statements Supported by MySQL
SELECTING, CREATING, DROPPING, AND ALTERING DATABASES
USE
CREATE DATABASE
DROP DATABASE
ALTER DATABASE
CREATING, ALTERING, AND DROPPING TABLES AND INDEXES
CREATE TABLE
DROP TABLE
CREATE INDEX
DROP INDEX
ALTER TABLE
GETTING INFORMATION ABOUT DATABASES AND TABLES
DESCRIBE
SHOW
RETRIEVING INFORMATION FROM TABLES
SELECT
UNION
PERFORMING TRANSACTIONS
SET AUTOCOMMIT
START TRANSACTION
COMMIT
ROLLBACK
MODIFYING INFORMATION IN TABLES
DELETE
INSERT
LOAD DATA
REPLACE
UPDATE
ADMINISTRATIVE STATEMENTS
FLUSH
GRANT
REVOKE
