PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
Trace files are generated by critical errors in ndbmtd processes in a somewhat different fashion from how these are generated by ndbd failures. Like ndbd, ndbmtd generates a set of log files which are placed in the directory specified by DataDir in ... ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
Secure-by-Default Deployment Current versions of mysql_install_db produce a MySQL deployment that is secure by default, with these characteristics: A single administrative account named 'root'@'localhost' is created with a randomly generated ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
If it is not possible to modify an offending query (for example, if it is generated by a third-party application), set the sql_mode system variable at server startup to not enable ONLY_FULL_GROUP_BY. System Table Changes Incompatible change: The ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
If strict SQL mode is enabled, an INSERT statement generates an error if it does not specify an explicit value for every column that has no default value. If a generated column is inserted into explicitly, the only permitted value is DEFAULT. For ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
NULL, 'NULL', and Empty Values: For a column named column_name, the NULL value, an empty string, and the string value 'NULL' are distinguished from one another in the output generated by this option as follows. The mysqldump command can also ... The ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
An error is generated if auto-positioning is enabled and an anonymous transaction is encountered. When the binary log is off and gtid_next is set to AUTOMATIC, then no GTID is generated. To be able to safely configure the replication mode of an ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
JSON columns, like columns of other binary types, are not indexed directly; instead, you can create an index on a generated column that extracts a scalar value from the JSON column. See Indexing a Generated Column to Provide a JSON Column Index, for ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
Note To store values generated by INET_ATON(), use an INT UNSIGNED column rather than INT, which is signed. There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. This may ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. LOAD DATA interprets all fields in ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...