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-command-options.html
This option is on by default, which enables database, table, and column name completion. The DROP TABLE and CREATE TABLE statements are not executed because the default database is not db1, even though the statements name a table in db1. The INSERT ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
You can do this by storing in a separate table the event names from the SELECT statement shown previously, or using ALTER EVENT statements to rename the events with a common prefix such as replicated_ to identify them. The following statements are ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. When ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. If you want to check a table, you should normally run myisamchk without options or with the -s (silent) option. This may take a long time for a ...What it cannot find is corruption that involves only the data file (which is very ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-blocks.html
The blocks table is a static table which simply contains the names and internal IDs of all NDB kernel blocks (see NDB Kernel Blocks). It is for use by the other ndbinfo tables (most of which are actually views) in mapping block numbers to block ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-transactions.html
The cluster_transactions table shows information about all ongoing transactions in an NDB Cluster. Together with the block name, this number can be used to look up a given instance in the threadblocks table. You can use this along with the block ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-params.html
The config_params table is a static table which provides the names and internal ID numbers of and other information about NDB Cluster configuration parameters. Although this is a static table, its content can vary between NDB Cluster installations, ...The param_description, param_type, param_default, param_min, param_max, param_mandatory, and param_status columns were all added in NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-values.html
The config_values table, implemented in NDB 7.5.0, provides information about the current state of node configuration parameter values. Each row in the table corresponds to the current value of a parameter on a given node. node_id ID of the node in ...You can obtain output that is more specific, more detailed, or both by issuing the proper ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
This table contains information on the status of data nodes. For each data node that is running in the cluster, a corresponding row in this table provides the node's node ID, status, and uptime. The nodes table contains the following columns: ...