MySQL 8.0 Reference Manual
3.6.1 The Maximum Value for a Column ......................................................................... 350
3.6.2 The Row Holding the Maximum of a Certain Column ............................................... 350
3.6.3 Maximum of Column per Group .............................................................................. 351
3.6.4 The Rows Holding the Group-wise Maximum of a Certain Column ............................ 351
3.6.5 Using User-Defined Variables ................................................................................. 352
3.6.6 Using Foreign Keys ................................................................................................ 353
3.6.7 Searching on Two Keys ......................................................................................... 355
3.6.8 Calculating Visits Per Day ...................................................................................... 355
3.6.9 Using AUTO_INCREMENT ..................................................................................... 356
3.7 Using MySQL with Apache ............................................................................................... 358
4 MySQL Programs ........................................................................................................................ 361
4.1 Overview of MySQL Programs .......................................................................................... 362
4.2 Using MySQL Programs ................................................................................................... 366
4.2.1 Invoking MySQL Programs ..................................................................................... 366
4.2.2 Specifying Program Options ................................................................................... 367
4.2.3 Command Options for Connecting to the Server ...................................................... 380
4.2.4 Connecting to the MySQL Server Using Command Options ...................................... 390
4.2.5 Connecting to the Server Using URI-Like Strings or Key-Value Pairs ......................... 393
4.2.6 Connecting to the Server Using DNS SRV Records ................................................. 400
4.2.7 Connection Transport Protocols .............................................................................. 402
4.2.8 Connection Compression Control ............................................................................ 404
4.2.9 Setting Environment Variables ................................................................................ 407
4.3 Server and Server-Startup Programs ................................................................................. 408
4.3.1 mysqld — The MySQL Server ................................................................................ 408
4.3.2 mysqld_safe — MySQL Server Startup Script .......................................................... 409
4.3.3 mysql.server — MySQL Server Startup Script ......................................................... 415
4.3.4 mysqld_multi — Manage Multiple MySQL Servers ................................................... 418
4.4 Installation-Related Programs ............................................................................................ 422
4.4.1 comp_err — Compile MySQL Error Message File .................................................... 422
4.4.2 mysql_secure_installation — Improve MySQL Installation Security ............................ 423
4.4.3 mysql_ssl_rsa_setup — Create SSL/RSA Files ....................................................... 427
4.4.4 mysql_tzinfo_to_sql — Load the Time Zone Tables ................................................. 430
4.4.5 mysql_upgrade — Check and Upgrade MySQL Tables ............................................ 430
4.5 Client Programs ................................................................................................................ 441
4.5.1 mysql — The MySQL Command-Line Client ............................................................ 441
4.5.2 mysqladmin — A MySQL Server Administration Program ......................................... 477
4.5.3 mysqlcheck — A Table Maintenance Program ......................................................... 490
4.5.4 mysqldump — A Database Backup Program ........................................................... 502
4.5.5 mysqlimport — A Data Import Program ................................................................... 533
4.5.6 mysqlpump — A Database Backup Program ........................................................... 544
4.5.7 mysqlshow — Display Database, Table, and Column Information ............................. 565
4.5.8 mysqlslap — A Load Emulation Client .................................................................... 574
4.6 Administrative and Utility Programs ................................................................................... 587
4.6.1 ibd2sdi — InnoDB Tablespace SDI Extraction Utility ................................................ 587
4.6.2 innochecksum — Offline InnoDB File Checksum Utility ............................................ 590
4.6.3 myisam_ftdump — Display Full-Text Index information ............................................. 595
4.6.4 myisamchk — MyISAM Table-Maintenance Utility .................................................... 597
4.6.5 myisamlog — Display MyISAM Log File Contents .................................................... 614
4.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables ......................... 615
4.6.7 mysql_config_editor — MySQL Configuration Utility ................................................. 621
4.6.8 mysql_migrate_keyring — Keyring Key Migration Utility ............................................ 628
4.6.9 mysqlbinlog — Utility for Processing Binary Log Files .............................................. 635
4.6.10 mysqldumpslow — Summarize Slow Query Log Files ............................................ 662
4.7 Program Development Utilities .......................................................................................... 664
v
评论0