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/mysqlpump.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --single-transaction Command-Line Format --single-transaction This option sets the transaction isolation mode to REPEATABLE READ and ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlshow.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated 8.0.34 Type Enumeration Default Value OFF ... The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
The following rules describe how conversion occurs for comparison operations: If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe <=> equality comparison operator. To be safe, always use complete ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
For UPDATE and DELETE statements, if the optimizer falls back to a full table scan and the sql_safe_updates system variable is enabled, an error occurs rather than a warning because, in effect, no key is used to determine which rows to modify. To ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
The IGNORE_SPACE SQL mode applies to built-in functions, not to stored routines. MySQL stores the sql_mode system variable setting in effect when a routine is created or altered, and always executes the routine with this setting in force, regardless ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html
To keep this file safe, use a restrictive access mode, the same way as described earlier for the .my.cnf file. In short, the safest methods are to have the client program prompt for the password or to specify the password in a properly protected ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. The only tables that would be safe from this sort of mayhem would be those tables that were ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. For best results, you should always use ...This advice applies whether you are using statement-based or row-based ...