MySQL 8.0 Reference Manual
Pre-General
Availability
Draft iv
Pre-General
Availability
Draft
2.5.4 Installing MySQL on Linux Using RPM Packages from Oracle ............................. 139
2.5.5 Installing MySQL on Linux Using Debian Packages from Oracle .......................... 143
2.5.6 Deploying MySQL on Linux with Docker ............................................................ 144
2.5.7 Installing MySQL on Linux from the Native Software Repositories ........................ 151
2.5.8 Installing MySQL on Linux with Juju .................................................................. 154
2.5.9 Managing MySQL Server with systemd ............................................................. 154
2.6 Installing MySQL on Solaris ......................................................................................... 159
2.6.1 Installing MySQL on Solaris Using a Solaris PKG .............................................. 160
2.7 Installing MySQL on FreeBSD ..................................................................................... 161
2.8 Installing MySQL from Source ..................................................................................... 162
2.8.1 MySQL Layout for Source Installation ................................................................ 164
2.8.2 Installing MySQL Using a Standard Source Distribution ...................................... 164
2.8.3 Installing MySQL Using a Development Source Tree .......................................... 169
2.8.4 MySQL Source-Configuration Options ............................................................... 170
2.8.5 Dealing with Problems Compiling MySQL .......................................................... 189
2.8.6 MySQL Configuration and Third-Party Tools ...................................................... 191
2.8.7 Generating MySQL Doxygen Documentation Content ......................................... 191
2.9 Postinstallation Setup and Testing ............................................................................... 192
2.9.1 Initializing the Data Directory ............................................................................ 193
2.9.2 Starting the Server ........................................................................................... 198
2.9.3 Testing the Server ............................................................................................ 200
2.9.4 Securing the Initial MySQL Account .................................................................. 202
2.9.5 Starting and Stopping MySQL Automatically ...................................................... 204
2.10 Upgrading or Downgrading MySQL ............................................................................ 205
2.10.1 Upgrading MySQL .......................................................................................... 205
2.10.2 Downgrading MySQL ...................................................................................... 222
2.10.3 Rebuilding or Repairing Tables or Indexes ....................................................... 227
2.10.4 Copying MySQL Databases to Another Machine .............................................. 228
2.11 Perl Installation Notes ................................................................................................ 229
2.11.1 Installing Perl on Unix ..................................................................................... 230
2.11.2 Installing ActiveState Perl on Windows ............................................................ 231
2.11.3 Problems Using the Perl DBI/DBD Interface ..................................................... 231
3 Tutorial .................................................................................................................................. 233
3.1 Connecting to and Disconnecting from the Server ......................................................... 233
3.2 Entering Queries ......................................................................................................... 234
3.3 Creating and Using a Database ................................................................................... 237
3.3.1 Creating and Selecting a Database ................................................................... 238
3.3.2 Creating a Table .............................................................................................. 239
3.3.3 Loading Data into a Table ................................................................................ 240
3.3.4 Retrieving Information from a Table ................................................................... 241
3.4 Getting Information About Databases and Tables ......................................................... 254
3.5 Using mysql in Batch Mode ......................................................................................... 255
3.6 Examples of Common Queries .................................................................................... 257
3.6.1 The Maximum Value for a Column .................................................................... 257
3.6.2 The Row Holding the Maximum of a Certain Column .......................................... 257
3.6.3 Maximum of Column per Group ........................................................................ 258
3.6.4 The Rows Holding the Group-wise Maximum of a Certain Column ....................... 258
3.6.5 Using User-Defined Variables ........................................................................... 259
3.6.6 Using Foreign Keys .......................................................................................... 259
3.6.7 Searching on Two Keys .................................................................................... 261
3.6.8 Calculating Visits Per Day ................................................................................. 261
3.6.9 Using AUTO_INCREMENT ............................................................................... 262
3.7 Using MySQL with Apache .......................................................................................... 264
4 MySQL Programs .................................................................................................................. 265
4.1 Overview of MySQL Programs ..................................................................................... 266
4.2 Using MySQL Programs .............................................................................................. 269
4.2.1 Invoking MySQL Programs ............................................................................... 269
4.2.2 Connecting to the MySQL Server ...................................................................... 270
4星 · 超过85%的资源 需积分: 50 111 浏览量
2018-02-09
11:15:36
上传
评论 2
收藏 35.84MB PDF 举报 
tqdonkey2018-05-14谢谢分享~~
machen_smiling2018-02-09牛逼了牛逼了
