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/create-table.html
The underlying file system may have a limit on the number of files that represent tables. In MySQL 8.0, only the InnoDB, MyISAM, and MEMORY storage engines support indexes on columns that can have NULL values. AUTO_INCREMENT An integer or ...| ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
That is, when restoring to multiple nodes in parallel, you must have an [api] or [mysqld] section in the cluster config.ini file available for each concurrent ndb_restore process. When TRUE, the --exclude-intermediate-sql-tables option keeps ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
Parameters Introduced in NDB 8.0 The following node configuration parameters have been added in NDB 8.0. Parameters Deprecated in NDB 8.0 The following node configuration parameters have been deprecated in NDB 8.0. Parameters Removed in NDB 8.0 No ...AllowUnresolvedHostNames: When false (default), failure by management node to resolve host name results in fatal error; when true, unresolved host names are reported as warnings ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
(The data directory normally is named data or var and is located under your MySQL installation directory.) Make sure that you have a file named user.MYD in the mysql database directory. See Section 2.9.4, “Securing the Initial MySQL Account” on ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
Particular SQL statements might have more specific privilege requirements than indicated here. If you have the CREATE privilege for a table, you can include index definitions in the CREATE TABLE statement. LOCK TABLES Enables use of explicit LOCK ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
The preceding example could have been written like this: SELECT CONCAT(last_name,', ',first_name) full_name FROM mytable ORDER BY full_name; However, because the AS is optional, a subtle problem can occur if you forget the comma between two ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
For example, because status variables are initialized for each server startup and do not persist across restarts, the Com_restart and Com_shutdown variables that track RESTART and SHUTDOWN statements normally have a value of zero, but can be nonzero ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
However, it also has compatibility implications that may affect existing MySQL installations: Clients and connectors that have not been updated to know about caching_sha2_password may have trouble connecting to a MySQL 8.0 server configured with ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
To grant a privilege with GRANT, you must have the GRANT OPTION privilege, and you must have the privileges that you are granting. (Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
The UUID value is assumed not to have its time-low and time-high parts swapped. If swap_flag is 1, the UUID value is assumed to have its time-low and time-high parts swapped. The use of DEFAULT(col_name) to specify the default value for a named ...