toc

Links

• Sites Page
• SQuirrel SQL – Universal SQL Client
• MySQL 101
• Order of clause execution / Why can't you use aliases in a GROUP BY clause

Bag

select sum(data_length+index_length) as total from information_schema.tables;

MySQL Docs

• Data Types
  • Storage Requirements
  • Data Types
    • Spatial Extensions
    • Numeric Types
    • Date and Time Types
    • String Types
• INFORMATION_SCHEMA Tables
• Functions and Operators
  • Function and Operator Reference
  • Type Conversion in Expression Evaluation
  • Operators
    • Operator Precedence
    • Comparison Functions and Operators
    • Logical Operators
    • Assignment Operators
  • Control Flow Functions
    • CASE
    • IF()
    • IFNULL()
    • NULLIF()
  • String Functions
  • Numeric Functions and Operators
  • Date and Time Functions
  • What Calendar Is Used By MySQL?
  • Full-Text Search Functions
  • Cast Functions and Operators
  • Bit Functions
  • Encryption and Compression Functions
  • Information Functions
  • Miscellaneous Functions
  • Functions and Modifiers for Use with GROUP BY Clauses
    • GROUP BY (Aggregate) Functions
    • GROUP BY Modifiers
    • GROUP BY and HAVING with Hidden Columns
  • Precision Math
    • Types of Numeric Values
    • DECIMAL Data Type Changes
    • Expression Handling
    • Rounding Behavior
    • Precision Math Examples
• SQL Statement Syntax
  • Data Definition Statements
    • ALTER DATABASE
    • ALTER FUNCTION
    • ALTER PROCEDURE
    • ALTER TABLE
    • ALTER VIEW
    • CREATE DATABASE
    • The CREATE FUNCTION Statement
    • CREATE INDEX
    • CREATE PROCEDURE and CREATE FUNCTION
    • CREATE TABLE
    • CREATE TRIGGER
    • CREATE VIEW
    • DROP DATABASE
    • DROP FUNCTION
    • DROP INDEX
    • DROP PROCEDURE and DROP FUNCTION
    • DROP TABLE
    • DROP TRIGGER
    • DROP VIEW
    • RENAME TABLE
    • TRUNCATE TABLE
  • Data Manipulation Statements
    • CALL
    • DELETE
    • DO
    • HANDLER
    • INSERT
      • INSERT ... SELECT
      • INSERT DELAYED
      • INSERT ... ON DUPLICATE KEY UPDATE
    • LOAD DATA INFILE
    • REPLACE
    • SELECT
      • SELECT ... INTO
      • JOIN
      • Index Hint
      • UNION
    • Subquery
      • The Subquery as Scalar Operand
      • Comparisons Using Subqueries
      • Subqueries with ANY, IN, or SOME
      • Subqueries with ALL
      • Row Subqueries
      • Subqueries with EXISTS or NOT EXISTS
      • Correlated Subqueries
      • Subqueries in the FROM Clause
      • Subquery Errors
      • Optimizing Subqueries
      • Rewriting Subqueries as Joins
    • UPDATE
  • MySQL Transactional and Locking Statements
  • Replication Statements
  • SQL Syntax for Prepared Statements
  • MySQL Compound-Statement Syntax
    • BEGIN ... END Compound-Statement
    • Statement Label
    • DECLARE
    • Variables in Stored Programs
    • Flow Control Statements
    • Cursors
    • Condition Handling
  • Database Administration Statements
  • MySQL Utility Statements
• Stored Programs and Views
• Optimization
• Index
  • C Function Index
  • Command Index
  • Function Index
  • INFORMATION_SCHEMA Index
  • Transaction Isolation Level Index
  • JOIN Types Index
  • Operator Index
  • Option Index
  • Privileges Index
  • SQL Modes Index
  • Status Variable Index
  • Statement/Syntax Index
  • System Variable Index

Reference

• 3. Tutorial [+/-]
  • 3.1. Connecting to and Disconnecting from the Server
  • 3.2. Entering Queries
  • 3.3. Creating and Using a Database [+/-]
    • 3.3.1. Creating and Selecting a Database
    • 3.3.2. Creating a Table
    • 3.3.3. Loading Data into a Table
    • 3.3.4. Retrieving Information from a Table
  • 3.4. Getting Information About Databases and Tables
  • 3.5. Using mysql in Batch Mode
  • 3.6. Examples of Common Queries [+/-]
    • 3.6.1. The Maximum Value for a Column
    • 3.6.2. The Row Holding the Maximum of a Certain Column
    • 3.6.3. Maximum of Column per Group
    • 3.6.4. The Rows Holding the Group-wise Maximum of a Certain Column
    • 3.6.5. Using User-Defined Variables
    • 3.6.6. Using Foreign Keys
    • 3.6.7. Searching on Two Keys
    • 3.6.8. Calculating Visits Per Day
    • 3.6.9. Using AUTO_INCREMENT
  • 3.7. Using MySQL with Apache
• 4. MySQL Programs [+/-]
  • 4.5. MySQL Client Programs [+/-]
    • 4.5.1. mysql — The MySQL Command-Line Tool
    • 4.5.2. mysqladmin — Client for Administering a MySQL Server
    • 4.5.3. mysqlcheck — A Table Maintenance Program
    • 4.5.4. mysqldump — A Database Backup Program
    • 4.5.5. mysqlimport — A Data Import Program
    • 4.5.6. mysqlshow — Display Database, Table, and Column Information
  • 5. MySQL Server Administration [+/-]
  • 5.1. The MySQL Server [+/-]
    • 5.1.1. Server Option and Variable Reference
    • 5.1.2. Server Command Options
    • 5.1.3. Server System Variables
    • 5.1.4. Using System Variables
    • 5.1.5. Server Status Variables
    • 5.1.6. Server SQL Modes
    • 5.1.9. The Shutdown Process
  • 5.2. MySQL Server Logs [+/-]
    • 5.2.1. The Error Log
    • 5.2.2. The General Query Log
    • 5.2.3. The Binary Log
    • 5.2.4. The Slow Query Log
    • 5.2.5. Server Log Maintenance
  • 5.3. General Security Issues [+/-]
  • 5.4. The MySQL Access Privilege System [+/-]
  • 5.5. MySQL User Account Management [+/-]
    • 5.5.1. User Names and Passwords
    • 5.5.8. Auditing MySQL Account Activity
• 7. Optimization [+/-]
  • 7.1. Optimization Overview [+/-]
    • 7.1.1. MySQL Design Limitations and Tradeoffs
    • 7.1.2. Designing Applications for Portability
    • 7.1.3. The MySQL Benchmark Suite
    • 7.1.4. Using Your Own Benchmarks
  • 7.2. Obtaining Query Execution Plan Information [+/-]
    • 7.2.1. Optimizing Queries with EXPLAIN
    • 7.2.2. EXPLAIN Output Format
    • 7.2.3. Estimating Query Performance
  • 7.3. Optimizing SQL Statements [+/-]
    • 7.3.1. Optimizing SELECT Statements
    • 7.3.2. Optimizing Non-SELECT Statements
    • 7.3.3. Other Optimization Tips
  • 7.4. Controlling the Query Optimizer
  • 7.5. Optimization and Indexes [+/-]
    • 7.5.1. Column Indexes
    • 7.5.2. Multiple-Column Indexes
    • 7.5.3. How MySQL Uses Indexes
  • 7.7. Locking Issues [+/-]
    • 7.7.1. Internal Locking Methods
    • 7.7.2. Table Locking Issues
    • 7.7.3. Concurrent Inserts
    • 7.7.4. External Locking
  • 7.8. Optimizing Database Structure [+/-]
    • 7.8.1. Make Your Data as Small as Possible
    • 7.8.2. How MySQL Opens and Closes Tables
    • 7.8.3. Disadvantages of Creating Many Tables in the Same Database
    • 7.8.4. How MySQL Uses Internal Temporary Tables
  • 7.9. Optimizing the MySQL Server [+/-]
  • 7.10. Examining Thread Information [+/-]
• 8. Language Structure [+/-]
  • 8.1. Literal Values [+/-]
    • 8.1.1. Strings
    • 8.1.2. Numbers
    • 8.1.3. Date and Time Values
    • 8.1.4. Hexadecimal Values
    • 8.1.5. Boolean Values
    • 8.1.6. Bit-Field Values
    • 8.1.7. NULL Values
  • 8.2. Schema Object Names [+/-]
    • 8.2.1. Identifier Qualifiers
    • 8.2.2. Identifier Case Sensitivity
    • 8.2.3. Function Name Parsing and Resolution
  • 8.3. Reserved Words
  • 8.4. User-Defined Variables
  • 8.5. Expression Syntax
  • 8.6. Comment Syntax
• 9. Globalization [+/-]
  • 9.1. Character Set Support [+/-]
    • 9.1.1. Character Sets and Collations in General
    • 9.1.2. Character Sets and Collations in MySQL
    • 9.1.3. Specifying Character Sets and Collations
    • 9.1.4. Connection Character Sets and Collations
    • 9.1.5. Configuring the Character Set and Collation for Applications
    • 9.1.6. Character Set for Error Messages
    • 9.1.7. Collation Issues
    • 9.1.8. String Repertoire
    • 9.1.9. Operations Affected by Character Set Support
    • 9.1.10. Unicode Support
    • 9.1.11. UTF-8 for Metadata
    • 9.1.12. Column Character Set Conversion
    • 9.1.13. Character Sets and Collations That MySQL Supports
  • 9.2. Setting the Error Message Language
  • 9.3. Adding a Character Set [+/-]
  • 9.4. Adding a Collation to a Character Set [+/-]
  • 9.5. Character Set Configuration
  • 9.6. MySQL Server Time Zone Support [+/-]
  • 9.7. MySQL Server Locale Support
• 10. Data Types [+/-]
  • 10.1. Data Type Overview [+/-]
  • 10.2. Numeric Types
  • 10.3. Date and Time Types [+/-]
    • 10.3.1. The DATETIME, DATE, and TIMESTAMP Types
    • 10.3.2. The TIME Type
    • 10.3.3. The YEAR Type
    • 10.3.4. Year 2000 Issues and Date Types
  • 10.4. String Types [+/-]
    • 10.4.1. The CHAR and VARCHAR Types
    • 10.4.2. The BINARY and VARBINARY Types
    • 10.4.3. The BLOB and TEXT Types
    • 10.4.4. The ENUM Type
    • 10.4.5. The SET Type
  • 10.5. Data Type Storage Requirements
  • 10.6. Out-of-Range and Overflow Handling
  • 10.7. Choosing the Right Type for a Column
• 11. Functions and Operators [+/-]
  • 11.1. Function and Operator Reference
  • 11.2. Type Conversion in Expression Evaluation
  • 11.3. Operators [+/-]
    • 11.3.1. Operator Precedence
    • 11.3.2. Comparison Functions and Operators
    • 11.3.3. Logical Operators
    • 11.3.4. Assignment Operators
  • 11.4. Control Flow Functions
  • 11.5. String Functions [+/-]
    • 11.5.1. String Comparison Functions
    • 11.5.2. Regular Expressions
  • 11.6. Numeric Functions and Operators [+/-]
    • 11.6.1. Arithmetic Operators
    • 11.6.2. Mathematical Functions
  • 11.7. Date and Time Functions
  • 11.8. What Calendar Is Used By MySQL?
  • 11.9. Full-Text Search Functions [+/-]
  • 11.10. Cast Functions and Operators
  • 11.11. Bit Functions
  • 11.12. Encryption and Compression Functions
  • 11.13. Information Functions
  • 11.14. Miscellaneous Functions
  • 11.15. Functions and Modifiers for Use with GROUP BY Clauses [+/-]
    • 11.15.1. GROUP BY (Aggregate) Functions
    • 11.15.2. GROUP BY Modifiers
    • 11.15.3. GROUP BY and HAVING with Hidden Columns
  • 11.16. Spatial Extensions [+/-]
  • 11.17. Precision Math [+/-]
    • 11.17.1. Types of Numeric Values
    • 11.17.2. DECIMAL Data Type Changes
    • 11.17.3. Expression Handling
    • 11.17.4. Rounding Behavior
    • 11.17.5. Precision Math Examples
• 12. SQL Statement Syntax [+/-]
  • 12.1. Data Definition Statements [+/-]
    • 12.1.1. ALTER DATABASE Syntax
    • 12.1.2. ALTER FUNCTION Syntax
    • 12.1.3. ALTER PROCEDURE Syntax
    • 12.1.4. ALTER TABLE Syntax
    • 12.1.5. ALTER VIEW Syntax
    • 12.1.6. CREATE DATABASE Syntax
    • 12.1.7. The CREATE FUNCTION Statement
    • 12.1.8. CREATE INDEX Syntax
    • 12.1.9. CREATE PROCEDURE and CREATE FUNCTION Syntax
    • 12.1.10. CREATE TABLE Syntax
    • 12.1.11. CREATE TRIGGER Syntax
    • 12.1.12. CREATE VIEW Syntax
    • 12.1.13. DROP DATABASE Syntax
    • 12.1.14. DROP FUNCTION Syntax
    • 12.1.15. DROP INDEX Syntax
    • 12.1.16. DROP PROCEDURE and DROP FUNCTION Syntax
    • 12.1.17. DROP TABLE Syntax
    • 12.1.18. DROP TRIGGER Syntax
    • 12.1.19. DROP VIEW Syntax
    • 12.1.20. RENAME TABLE Syntax
    • 12.1.21. TRUNCATE TABLE Syntax
  • 12.2. Data Manipulation Statements [+/-]
    • 12.2.1. CALL Syntax
    • 12.2.2. DELETE Syntax
    • 12.2.3. DO Syntax
    • 12.2.4. HANDLER Syntax
    • 12.2.5. INSERT Syntax
    • 12.2.6. LOAD DATA INFILE Syntax
    • 12.2.7. REPLACE Syntax
    • 12.2.8. SELECT Syntax
    • 12.2.9. Subquery Syntax
    • 12.2.10. UPDATE Syntax
  • 12.3. MySQL Transactional and Locking Statements [+/-]
    • 12.3.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax
    • 12.3.2. Statements That Cannot Be Rolled Back
    • 12.3.3. Statements That Cause an Implicit Commit
    • 12.3.4. SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
    • 12.3.5. LOCK TABLES and UNLOCK TABLES Syntax
    • 12.3.6. SET TRANSACTION Syntax
    • 12.3.7. XA Transactions
  • 12.4. Replication Statements [+/-]
  • 12.5. SQL Syntax for Prepared Statements [+/-]
    • 12.5.1. PREPARE Syntax
    • 12.5.2. EXECUTE Syntax
    • 12.5.3. DEALLOCATE PREPARE Syntax
  • 12.6. MySQL Compound-Statement Syntax [+/-]
    • 12.6.1. BEGIN ... END Compound-Statement Syntax
    • 12.6.2. Statement Label Syntax
    • 12.6.3. DECLARE Syntax
    • 12.6.4. Variables in Stored Programs
    • 12.6.5. Flow Control Statements
    • 12.6.6. Cursors
    • 12.6.7. Condition Handling
  • 12.7. Database Administration Statements [+/-]
    • 12.7.1. Account Management Statements
    • 12.7.2. Table Maintenance Statements
    • 12.7.3. User-Defined Function Statements
    • 12.7.4. SET Syntax
    • 12.7.5. SHOW Syntax
    • 12.7.6. Other Administrative Statements
  • 12.8. MySQL Utility Statements [+/-]
    • 12.8.1. DESCRIBE Syntax
    • 12.8.2. EXPLAIN Syntax
    • 12.8.3. HELP Syntax
    • 12.8.4. USE Syntax
• 17. Stored Programs and Views [+/-]
  • 17.1. Defining Stored Programs
  • 17.2. Using Stored Routines (Procedures and Functions) [+/-]
    • 17.2.1. Stored Routine Syntax
    • 17.2.2. Stored Routines and MySQL Privileges
    • 17.2.3. Stored Routine Metadata
    • 17.2.4. Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
  • 17.3. Using Triggers [+/-]
    • 17.3.1. Trigger Syntax
    • 17.3.2. Trigger Metadata
  • 17.4. Using Views [+/-]
    • 17.4.1. View Syntax
    • 17.4.2. View Processing Algorithms
    • 17.4.3. Updatable and Insertable Views
    • 17.4.4. View Metadata
  • 17.5. Access Control for Stored Programs and Views
  • 17.6. Binary Logging of Stored Programs
• 18. INFORMATION_SCHEMA Tables [+/-]
  • 18.19. Extensions to SHOW Statements
• 20. Extending MySQL [+/-]
  • 20.1. MySQL Internals [+/-]
    • 20.1.1. MySQL Threads
    • 20.1.2. The MySQL Test Suite
  • 20.2. Adding New Functions to MySQL [+/-]
    • 20.2.1. Features of the User-Defined Function Interface
    • 20.2.2. Adding a New User-Defined Function
    • 20.2.3. Adding a New Native Function
  • 20.3. Adding New Procedures to MySQL [+/-]
    • 20.3.1. PROCEDURE ANALYSE
    • 20.3.2. Writing a Procedure
  • 20.4.3. The DBUG Package
• FAQ
  • B.1. MySQL 5.0 FAQ: General
  • B.2. MySQL 5.0 FAQ: Storage Engines
  • B.3. MySQL 5.0 FAQ: Server SQL Mode
  • B.4. MySQL 5.0 FAQ: Stored Procedures and Functions
  • B.5. MySQL 5.0 FAQ: Triggers
  • B.6. MySQL 5.0 FAQ: Views
  • B.7. MySQL 5.0 FAQ: INFORMATION_SCHEMA
  • B.9. MySQL 5.0 FAQ: Security
  • B.12. MySQL 5.0 FAQ: Connectors & APIs
  • B.13. MySQL 5.0 FAQ: Replication
  • B.14. MySQL 5.0 FAQ: MySQL, DRBD, and Heartbeat [+/-]
• C. Errors, Error Codes, and Common Problems [+/-]
• C.5.8. Known Issues in MySQL

• E. Restrictions and Limits [+/-]

  • E.1. Restrictions on Stored Programs
  • E.2. Restrictions on Server-Side Cursors
  • E.3. Restrictions on Subqueries
  • E.4. Restrictions on Views
  • E.5. Restrictions on XA Transactions
  • E.6. Restrictions on Character Sets
  • E.7. Limits in MySQL [+/-]
    • E.7.1. Limits of Joins
  • E.7.2. Limits on Number of Databases and Tables
    • E.7.3. Limits on Table Size
  • E.7.4. Table Column-Count and Row-Size Limits

• Index

• Standard Index
• C Function Index
• Command Index
• Function Index
• INFORMATION_SCHEMA Index
• Transaction Isolation Level Index
• JOIN Types Index
• Operator Index
• Option Index
• Privileges Index
• SQL Modes Index
• Status Variable Index
• Statement/Syntax Index
• System Variable Index