PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
Beginning with NDB 7.5.4, you can obtain such information, using the mysql client, from the table_distribution_status, table_fragments, table_info, and table_replicas tables in the ndbinfo database. --context, -x Show additional contextual ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME can also be used to move a table to a different database. Regardless of the statement used, if the rename operation would move the table to a database located on a different file system, the success of the outcome is platform specific and ...
https://dev.mysql.com/doc/refman/5.7/en/testing-server.html
Use mysqlshow to see what databases exist: $> bin/mysqlshow +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ The list of installed databases may vary, ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
For information about replacing third-party packages with official MySQL packages, see the related APT guide or Yum guide. These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. These trigger_event values are permitted: INSERT: The trigger activates whenever a new row is inserted into the ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL accounts. Replace root-password in the examples with the password that you want to use. This section ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
To keep code portable across databases, it is recommended that you use LEFT JOIN instead of RIGHT JOIN. MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server-side-help.html
The proper operation of this command requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, “Server-Side Help Support”). To make a more specific request, please type 'help <item>', ...
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
(MySQL Enterprise Edition only) MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against lists of accepted statement patterns. Data masking ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
That shortcoming can lead to problems backing up a database with mysqldump, which may fail due to insufficient privileges. To modify the definition, drop and create the view again with DROP VIEW and CREATE VIEW, or replace the definition with CREATE ... The maximum number of tables that can be referenced in the definition of a view is ...