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/data-type-defaults.html
See Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. The exception is that, for TIMESTAMP and DATETIME columns, you can specify CURRENT_TIMESTAMP as the default. See Section 13.2.5, “Automatic Initialization ...Some aspects of explicit DEFAULT clause handling are version dependent, as described ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-format.html
2020-08-06T14:25:03.109022Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5 Traditional-format messages have these fields: time thread [label] [err_code] [subsystem] msg The [ and ] square bracket characters are ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-event-tables.html
For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current events. For each event type, the Performance Schema uses three tables for storing current and historical events. Typical autosized values are ...In addition, when events end, the Performance Schema can store them in history ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. near 'interval (begin INT, end INT)' BEGIN and END are keywords but not reserved, so their use as ...This may also be true for the names of built-in ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is: Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key ...You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the ... A MySQL client on Unix can connect to the mysqld server in two ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
If the timeout is 0, there is no waiting and the function produces an error if locks cannot be acquired immediately. One set of functions permits the server's list of version tokens to be manipulated and inspected. Another set of functions permits ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance.html
Expelled members automatically attempt to rejoin the group, and are brought up to date by distributed recovery. Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated recovery. If a member ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and ...Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which are discussed in Section 8.2.3, “Grant ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...Built-In Function Name Parsing Function Name Resolution Built-In Function ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. The easiest way to accomplish this ...There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage ...