MySQL 5.6 Reference Manual
iv
Installing MySQL on Solaris and OpenSolaris .................................................................... 109
Installing MySQL on Solaris using a Solaris PKG ........................................................ 110
Installing MySQL on OpenSolaris using IPS ............................................................... 111
Installing MySQL on HP-UX .............................................................................................. 112
General Notes on Installing MySQL on HP-UX ........................................................... 112
Installing MySQL on HP-UX using DEPOT ................................................................ 112
Installing MySQL on FreeBSD ........................................................................................... 113
Installing MySQL from Source ........................................................................................... 113
MySQL Layout for Source Installation ........................................................................ 115
Installing MySQL from a Standard Source Distribution ................................................ 115
Installing MySQL from a Development Source Tree .................................................... 119
MySQL Source-Configuration Options ........................................................................ 120
Dealing with Problems Compiling MySQL .................................................................. 128
MySQL Configuration and Third-Party Tools .............................................................. 130
Postinstallation Setup and Testing ..................................................................................... 130
Unix Postinstallation Procedures ............................................................................... 130
Securing the Initial MySQL Accounts ......................................................................... 141
Upgrading or Downgrading MySQL ................................................................................... 144
Upgrading MySQL .................................................................................................... 145
Downgrading MySQL ................................................................................................ 150
Checking Whether Tables or Indexes Must Be Rebuilt ................................................ 151
Rebuilding or Repairing Tables or Indexes ................................................................. 153
Copying MySQL Databases to Another Machine ........................................................ 155
Environment Variables ...................................................................................................... 156
Perl Installation Notes ....................................................................................................... 157
Installing Perl on Unix ............................................................................................... 157
Installing ActiveState Perl on Windows ...................................................................... 158
Problems Using the Perl DBI/DBD Interface ............................................................... 159
3. Tutorial ................................................................................................................................ 161
Connecting to and Disconnecting from the Server .............................................................. 161
Entering Queries .............................................................................................................. 162
Creating and Using a Database ........................................................................................ 165
Creating and Selecting a Database ........................................................................... 166
Creating a Table ...................................................................................................... 167
Loading Data into a Table ........................................................................................ 168
Retrieving Information from a Table ........................................................................... 169
Getting Information About Databases and Tables ............................................................... 181
Using mysql in Batch Mode ............................................................................................. 182
Examples of Common Queries .......................................................................................... 183
The Maximum Value for a Column ............................................................................ 184
The Row Holding the Maximum of a Certain Column .................................................. 184
Maximum of Column per Group ................................................................................ 185
The Rows Holding the Group-wise Maximum of a Certain Column ............................... 185
Using User-Defined Variables ................................................................................... 186
Using Foreign Keys .................................................................................................. 186
Searching on Two Keys ............................................................................................ 187
Calculating Visits Per Day ......................................................................................... 188
Using AUTO_INCREMENT .......................................................................................... 188
Using MySQL with Apache ............................................................................................... 190
4. MySQL Programs ................................................................................................................. 191
Overview of MySQL Programs .......................................................................................... 192
Using MySQL Programs ................................................................................................... 196
Invoking MySQL Programs ....................................................................................... 196
Connecting to the MySQL Server .............................................................................. 197
Specifying Program Options ...................................................................................... 200
Setting Environment Variables ................................................................................... 212
MySQL Server and Server-Startup Programs ..................................................................... 213
mysqld — The MySQL Server ................................................................................. 213
- 1
- 2
前往页