MySQL 5.0 Reference Manual
iv
2.10.7. Windows Postinstallation Procedures ................................................................ 88
2.10.8. Installing MySQL from Source on Windows ....................................................... 90
2.11. Installing MySQL on Mac OS X .................................................................................. 95
2.12. Installing MySQL from RPM Packages on Linux .......................................................... 97
2.13. Installing MySQL on Solaris ...................................................................................... 100
2.14. Installing MySQL on i5/OS ........................................................................................ 101
2.15. Installing MySQL on NetWare ................................................................................... 105
2.16. Installing MySQL from Generic Binaries on Other Unix-Like Systems ........................... 107
2.17. Installing MySQL from Source ................................................................................... 109
2.17.1. Installing MySQL from a Standard Source Distribution ..................................... 110
2.17.2. Installing MySQL from a Development Source Tree ......................................... 113
2.17.3. MySQL Source-Configuration Options ............................................................. 115
2.17.4. Dealing with Problems Compiling MySQL ....................................................... 123
2.17.5. Compiling and Linking an Optimized
mysqld
Server ....................................... 126
2.18. Postinstallation Setup and Testing ............................................................................. 127
2.18.1. Unix Postinstallation Procedures ..................................................................... 127
2.18.2. Securing the Initial MySQL Accounts .............................................................. 138
2.19. Upgrading or Downgrading MySQL ........................................................................... 142
2.19.1. Upgrading MySQL ......................................................................................... 142
2.19.2. Downgrading MySQL ..................................................................................... 153
2.19.3. Checking Whether Tables or Indexes Must Be Rebuilt ..................................... 154
2.19.4. Rebuilding or Repairing Tables or Indexes ...................................................... 156
2.19.5. Copying MySQL Databases to Another Machine ............................................. 158
2.20. Operating System-Specific Notes .............................................................................. 159
2.20.1. Linux Notes ................................................................................................... 159
2.20.2. Mac OS X Notes ........................................................................................... 165
2.20.3. Solaris Notes ................................................................................................. 165
2.20.4. BSD Notes .................................................................................................... 169
2.20.5. Other Unix Notes ........................................................................................... 172
2.20.6. OS/2 Notes ................................................................................................... 187
2.21. Environment Variables .............................................................................................. 187
2.22. Perl Installation Notes ............................................................................................... 188
2.22.1. Installing Perl on Unix .................................................................................... 189
2.22.2. Installing ActiveState Perl on Windows ........................................................... 190
2.22.3. Problems Using the Perl
DBI
/
DBD
Interface ..................................................... 190
3. Tutorial ................................................................................................................................. 193
3.1. Connecting to and Disconnecting from the Server ........................................................ 193
3.2. Entering Queries ........................................................................................................ 194
3.3. Creating and Using a Database .................................................................................. 197
3.3.1. Creating and Selecting a Database .................................................................. 198
3.3.2. Creating a Table .............................................................................................. 199
3.3.3. Loading Data into a Table ................................................................................ 200
3.3.4. Retrieving Information from a Table .................................................................. 201
3.4. Getting Information About Databases and Tables ......................................................... 213
3.5. Using
mysql
in Batch Mode ....................................................................................... 214
3.6. Examples of Common Queries .................................................................................... 216
3.6.1. The Maximum Value for a Column ................................................................... 216
3.6.2. The Row Holding the Maximum of a Certain Column ......................................... 216
3.6.3. Maximum of Column per Group ....................................................................... 217
3.6.4. The Rows Holding the Group-wise Maximum of a Certain Column ...................... 217
3.6.5. Using User-Defined Variables ........................................................................... 218
3.6.6. Using Foreign Keys ......................................................................................... 218
3.6.7. Searching on Two Keys ................................................................................... 220
3.6.8. Calculating Visits Per Day ................................................................................ 220
3.6.9. Using
AUTO_INCREMENT
................................................................................. 220
3.7. Using MySQL with Apache ......................................................................................... 222
4. MySQL Programs .................................................................................................................. 223
4.1. Overview of MySQL Programs .................................................................................... 224
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...