PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
The output does not explicitly list the table default character set, but the collation name begins with the character set name. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but ...
https://dev.mysql.com/doc/refman/8.0/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.
https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.0 to MySQL 5.7, or from a MySQL 8.0 release to a previous MySQL 8.0 release, is not supported.
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data directory and create the MySQL grant tables. Windows installation ...
https://dev.mysql.com/doc/refman/8.0/en/windows-start-command-line.html
The MySQL server can be started manually from the command line. To start the mysqld server from the command line, you should start a console window (or “DOS window”) and enter this command: C:\> "C:\Program Files\MySQL\MySQL Server ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
The scope indicates which client connections the profile applies to: The firewall supports account-based profiles such that each profile matches a particular client account (client user name and host name combination). Place the trained profiles in ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-hashicorp-plugin.html
Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by keyring_hashicorp, see Section 8.4.4.13, “Supported ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation.html
Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation location. For a list of systems on which MySQL is known to run, see ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
row *************************** Table: shirt Create Table: CREATE TABLE `shirt` ( `id` smallint(5) unsigned NOT NULL auto_increment, `style` enum('t-shirt','polo','dress') NOT NULL, `color` enum('red','blue','orange','white','black') NOT NULL, ...