Abstract
This is the MySQL Reference Manual. It documents MySQL 5.0 up through 5.0.16.
Document generated on: 2005-11-16
Table of Contents
AUTO_INCREMENTAccess denied ErrorsSELECT Statements and Other QueriesEXPLAIN Syntax (Get Information About a SELECT)SELECT QueriesWHERE ClausesIS NULLDISTINCTLEFT JOIN and RIGHT JOINORDER BYGROUP BYLIMITINSERT StatementsUPDATE StatementsDELETE StatementsMyISAM Key CacheMyISAM Index Statistics CollectionCOLLATE in SQL StatementsCOLLATE Clause PrecedenceBINARY OperatorGROUP BY ClausesMyISAM Storage EngineInnoDB Storage EngineInnoDB OverviewInnoDB Contact InformationInnoDB ConfigurationInnoDB Startup OptionsInnoDB TablespaceInnoDB TablesInnoDB Data and Log FilesInnoDB DatabaseInnoDB Database to Another MachineInnoDB Transaction Model and LockingInnoDB Performance Tuning TipsInnoDB TablesInnoDB TroubleshootingMERGE Storage EngineMEMORY (HEAP) Storage EngineBDB (BerkeleyDB) Storage EngineEXAMPLE Storage EngineFEDERATED Storage EngineARCHIVE Storage EngineCSV Storage EngineBLACKHOLE Storage EngineGeometryPointCurveLineStringSurfacePolygonGeometryCollectionMultiPointMultiCurveMultiLineStringMultiSurfaceMultiPolygonGeometry FunctionsCREATE PROCEDURE and CREATE FUNCTIONALTER PROCEDURE and ALTER FUNCTIONDROP PROCEDURE and DROP FUNCTIONSHOW CREATE PROCEDURE and SHOW CREATE FUNCTIONSHOW PROCEDURE STATUS and SHOW FUNCTION STATUSCALL StatementBEGIN ... END Compound StatementDECLARE StatementINFORMATION_SCHEMA Information DatabaseINFORMATION_SCHEMA TablesINFORMATION_SCHEMA SCHEMATA TableINFORMATION_SCHEMA TABLES TableINFORMATION_SCHEMA COLUMNS TableINFORMATION_SCHEMA STATISTICS TableINFORMATION_SCHEMA USER_PRIVILEGES TableINFORMATION_SCHEMA SCHEMA_PRIVILEGES TableINFORMATION_SCHEMA TABLE_PRIVILEGES TableINFORMATION_SCHEMA COLUMN_PRIVILEGES TableINFORMATION_SCHEMA CHARACTER_SETS TableINFORMATION_SCHEMA COLLATIONS TableINFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY TableINFORMATION_SCHEMA TABLE_CONSTRAINTS TableINFORMATION_SCHEMA KEY_COLUMN_USAGE TableINFORMATION_SCHEMA ROUTINES TableINFORMATION_SCHEMA VIEWS TableINFORMATION_SCHEMA TRIGGERS TableINFORMATION_SCHEMA TablesSHOW StatementslibmysqldAccess deniedCan't connect to [local] MySQL serverClient does not support authentication protocolHost 'host_name' is blockedToo many connectionsOut of memoryMySQL server has gone awayPacket too largeThe table is fullCan't create/write to fileCommands out of syncIgnoring userTable 'tbl_name' doesn't existCan't initialize character setDATE ColumnsNULL ValuesMySQL Cluster Change HistoryList of Tables
List of Examples