Mysql

MySQL Tutorial

MySQL Tutorial
Abstract This is the MySQL Tutorial from the MySQL 5.0 Reference Manual. Document generated on: 2013-03-06 (revision: 34547)

Table of Contents
Preface and Legal Notices ............................................................................................................ v 1. Tutorial..................................................................................................................................... 1 2. Connecting to and Disconnecting from the Server ...................................................................... 3 3. Entering Queries ....................................................................................................................... 5 4. Creating and Using a Database................................................................................................ 9 4.1. Creating and Selecting a Database ............................................................................... 10 4.2. Creating a Table .......................................................................................................... 11 4.3. Loading Data into a Table............................................................................................ 12 4.4. Retrieving Information from a Table .............................................................................. 13 4.4.1. Selecting All Data .............................................................................................. 13 4.4.2. Selecting Particular Rows.................................................................................. 14 4.4.3. Selecting Particular Columns ............................................................................. 15 4.4.4. Sorting Rows ..................................................................................................... 16 4.4.5. Date Calculations .............................................................................................. 174.4.6. Working with NULL Values ................................................................................. 19 4.4.7. Pattern Matching ............................................................................................... 20 4.4.8. Counting Rows .................................................................................................. 22 4.4.9. Using More Than one Table.............................................................................. 24 5. Getting Information About Databases and Tables ..................................................................... 27 6. Using mysql in Batch Mode ................................................................................................... 29 7. Examples of Common Queries................................................................................................ 31 7.1. The Maximum Value for a Column ................................................................................ 31 7.2. The Row Holding the Maximum of a Certain Column ..................................................... 32 7.3. Maximum of Column per Group.................................................................................... 32 7.4. The Rows Holding the Group-wise Maximum of a Certain Column .................................. 32 7.5. Using User-Defined Variables ....................................................................................... 33 7.6. Using Foreign Keys ...................................................................................................... 33 7.7.Searching on Two Keys ............................................................................................... 35 7.8. Calculating Visits Per Day ............................................................................................ 35 7.9. Using AUTO_INCREMENT .............................................................................................. 35 8. Using MySQL with Apache...