MySQL 5.7 Reference Manual
MySQL 5.7 Release Notes
Abstract
This is the MySQL Tutorial from the MySQL 5.7 Reference Manual.
For legal information, see the Legal Notices.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2024-10-29 (revision: 80141)
Table of Contents
- Preface and Legal Notices
- 1 Tutorial
- 2 Connecting to and Disconnecting from the Server
- 3 Entering Queries
- 4 Creating and Using a Database
- 5 Getting Information About Databases and Tables
- 6 Using mysql in Batch Mode
- 7 Examples of Common Queries
- 7.1 The Maximum Value for a Column
- 7.2 The Row Holding the Maximum of a Certain Column
- 7.3 Maximum of Column per Group
- 7.4 The Rows Holding the Group-wise Maximum of a Certain Column
- 7.5 Using User-Defined Variables
- 7.6 Using Foreign Keys
- 7.7 Searching on Two Keys
- 7.8 Calculating Visits Per Day
- 7.9 Using AUTO_INCREMENT
- 8 Using MySQL with Apache