MySQL language reference

• Base Syntax: Literals. That is how are strings and numbers written?
• Column types: Column types.
• Functions: Functions
• Create database: Create database syntax.
• Drop database: Drop database syntax.
• Create table: CREATE TABLE syntax.
• Alter table: ALTER TABLE syntax
• Delete table: DROP TABLE syntax.
• Delete: DELETE syntax.
• Select: SELECT syntax
• Join: Join syntax
• Insert: INSERT syntax
• Replace: REPLACE syntax
• Load: LOAD DATA INFILE syntax
• Update: UPDATE syntax
• Show: SHOW syntax. Get information about tables, columns...
• Explain: EXPLAIN syntax. Get information about a SELECT.
• Describe: DESCRIBE syntax. Get information about names of columns.
• Lock tables: LOCK TABLES syntax.
• Set option: SET OPTION syntax.
• Grant: GRANT syntax. (Compatibility function).
• Create Index: Create index syntax. (Compatibility function).
• Drop Index: Drop index syntax. (Compatibility function).
• Comments: Comment syntax
• UDF functions: CREATE FUNCTION syntax
• Reserved words: Is MySQL picky about reserved words?

Go to the first, previous, next, last section, table of contents.