PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
DROP PARTITION, see Section 15.1.9, “ALTER TABLE Statement”.) NULL is also treated in this way for partitioning expressions that use SQL functions. Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
Adding an AUTO_INCREMENT column to a table with ALTER TABLE might not produce the same ordering of the rows on the replica and the source. Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
You can use the --log-bin option to specify an alternative location, by adding a leading absolute path name to the base name to specify a different directory. For example, DDL statements such as CREATE TABLE and ALTER TABLE are always logged as ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
Another alternative for mysqldump is to disable engine types that you do not want to use on the replica before using the dump to build the data on the replica. Instead, use ALTER TABLE to change the table types after the replica has been started.
https://dev.mysql.com/doc/refman/8.0/en/roles.html
This enables assignment of sets of privileges to accounts and provides a convenient alternative to granting individual privileges, both for conceptualizing desired privilege assignments and implementing them. Instead, use an alternative GRANT syntax ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/doc/refman/8.0/en/set-default-role.html
However, ALTER USER can set the default for only a single user, whereas SET DEFAULT ROLE can set the default for multiple users. On the other hand, you can specify CURRENT_USER as the user name for the ALTER USER statement, whereas you cannot for ...
https://dev.mysql.com/doc/refman/8.0/en/show-privileges.html
row *************************** Privilege: Alter Context: Tables Comment: To alter the table *************************** 2. row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
The ALTER ROUTINE privilege is needed to alter or drop stored routines. If the automatic_sp_privileges system variable is 0, the EXECUTE and ALTER ROUTINE privileges are not automatically granted to and dropped from the routine creator. With the ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
Stored routines can be dropped with the DROP PROCEDURE and DROP FUNCTION statements (see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”), and altered with the ALTER PROCEDURE and ALTER FUNCTION statements (see Section 15.1.7, ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
For InnoDB tables, use the alternative technique explained in Section 17.6.1.2, “Creating Tables Externally” instead. Alternatively, if mysqld is not running, symlinking can be accomplished manually using ln -s from the command line. The same is ... Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; expect these to be removed in a future version of ...