MySQL 5.7 Reference Manual
3.3.4 Retrieving Information from a Table ........................................................................ 278
3.4 Getting Information About Databases and Tables ............................................................... 291
3.5 Using mysql in Batch Mode .............................................................................................. 292
3.6 Examples of Common Queries .......................................................................................... 294
3.6.1 The Maximum Value for a Column ......................................................................... 294
3.6.2 The Row Holding the Maximum of a Certain Column ............................................... 294
3.6.3 Maximum of Column per Group .............................................................................. 295
3.6.4 The Rows Holding the Group-wise Maximum of a Certain Column ............................ 295
3.6.5 Using User-Defined Variables ................................................................................. 296
3.6.6 Using Foreign Keys ................................................................................................ 296
3.6.7 Searching on Two Keys ......................................................................................... 299
3.6.8 Calculating Visits Per Day ...................................................................................... 299
3.6.9 Using AUTO_INCREMENT ..................................................................................... 299
3.7 Using MySQL with Apache ............................................................................................... 302
4 MySQL Programs ........................................................................................................................ 303
4.1 Overview of MySQL Programs .......................................................................................... 304
4.2 Using MySQL Programs ................................................................................................... 308
4.2.1 Invoking MySQL Programs ..................................................................................... 308
4.2.2 Specifying Program Options ................................................................................... 309
4.2.3 Command Options for Connecting to the Server ...................................................... 322
4.2.4 Connecting to the MySQL Server Using Command Options ...................................... 332
4.2.5 Connection Transport Protocols .............................................................................. 334
4.2.6 Connection Compression Control ............................................................................ 336
4.2.7 Setting Environment Variables ................................................................................ 336
4.3 Server and Server-Startup Programs ................................................................................. 337
4.3.1 mysqld — The MySQL Server ................................................................................ 337
4.3.2 mysqld_safe — MySQL Server Startup Script .......................................................... 338
4.3.3 mysql.server — MySQL Server Startup Script ......................................................... 345
4.3.4 mysqld_multi — Manage Multiple MySQL Servers ................................................... 347
4.4 Installation-Related Programs ............................................................................................ 351
4.4.1 comp_err — Compile MySQL Error Message File .................................................... 351
4.4.2 mysql_install_db — Initialize MySQL Data Directory ................................................ 352
4.4.3 mysql_plugin — Configure MySQL Server Plugins ................................................... 359
4.4.4 mysql_secure_installation — Improve MySQL Installation Security ............................ 361
4.4.5 mysql_ssl_rsa_setup — Create SSL/RSA Files ....................................................... 365
4.4.6 mysql_tzinfo_to_sql — Load the Time Zone Tables ................................................. 367
4.4.7 mysql_upgrade — Check and Upgrade MySQL Tables ............................................ 368
4.5 Client Programs ................................................................................................................ 376
4.5.1 mysql — The MySQL Command-Line Client ............................................................ 376
4.5.2 mysqladmin — A MySQL Server Administration Program ......................................... 408
4.5.3 mysqlcheck — A Table Maintenance Program ......................................................... 419
4.5.4 mysqldump — A Database Backup Program ........................................................... 431
4.5.5 mysqlimport — A Data Import Program ................................................................... 457
4.5.6 mysqlpump — A Database Backup Program ........................................................... 467
4.5.7 mysqlshow — Display Database, Table, and Column Information ............................. 484
4.5.8 mysqlslap — A Load Emulation Client .................................................................... 492
4.6 Administrative and Utility Programs ................................................................................... 504
4.6.1 innochecksum — Offline InnoDB File Checksum Utility ............................................ 504
4.6.2 myisam_ftdump — Display Full-Text Index information ............................................. 509
4.6.3 myisamchk — MyISAM Table-Maintenance Utility .................................................... 510
4.6.4 myisamlog — Display MyISAM Log File Contents .................................................... 527
4.6.5 myisampack — Generate Compressed, Read-Only MyISAM Tables ......................... 528
4.6.6 mysql_config_editor — MySQL Configuration Utility ................................................. 535
4.6.7 mysqlbinlog — Utility for Processing Binary Log Files .............................................. 541
v
评论0