Skip to Main Content
The world's most popular open source database
Contact MySQL  | 
Login  |  Register
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
MySQL 9.7 Reference Manual
  • Preface and Legal Notices
  • General Information
  • Installing MySQL
  • Upgrading MySQL
  • Downgrading MySQL
  • Tutorial
    • Connecting to and Disconnecting from the Server
    • Entering Queries
    • Creating and Using a Database
      • Creating and Selecting a Database
      • Creating a Table
      • Loading Data into a Table
      • Retrieving Information from a Table
        • Selecting All Data
        • Selecting Particular Rows
        • Selecting Particular Columns
        • Sorting Rows
        • Date Calculations
        • Working with NULL Values
        • Pattern Matching
        • Counting Rows
        • Using More Than one Table
    • Getting Information About Databases and Tables
    • Using mysql in Batch Mode
    • Examples of Common Queries
      • The Maximum Value for a Column
      • The Row Holding the Maximum of a Certain Column
      • Maximum of Column per Group
      • The Rows Holding the Group-wise Maximum of a Certain Column
      • Using User-Defined Variables
      • Using Foreign Keys
      • Searching on Two Keys
      • Calculating Visits Per Day
      • Using AUTO_INCREMENT
    • Using MySQL with Apache
  • MySQL Programs