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/data-dictionary-usage-differences.html
ALTER TABLE tbl_name ENGINE=engine_name fails because it updates the storage engine designation, which is stored in the data dictionary. Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
See Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
The ordering constraint also applies to the use of ALTER TABLE to reorder table columns. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html
However, there may be some alteration of the value or loss of information. To some extent, you can convert a value from one temporal type to another. In all cases, conversion between temporal types is subject to the range of valid values for the ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
Given a partitioned table t with a partition named p0, executing the statement DELETE FROM t PARTITION (p0) has the same effect on the table as executing ALTER TABLE t TRUNCATE PARTITION (p0); in both cases, all rows in partition p0 are dropped.
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; ...
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
(DROP FUNCTION is also used to drop loadable functions; see Section 15.7.4.2, “DROP FUNCTION Statement for Loadable Functions”.) To drop a stored routine, you must have the ALTER ROUTINE privilege for it. DROP {PROCEDURE | FUNCTION} [IF EXISTS] ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
A warning is also returned if you set the deprecated protocols at runtime and implement them using the ALTER INSTANCE RELOAD TLS statement. MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. The ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
Alternatively, you can use ON (or 1) or OFF (or 0) in place of the DISABLED value when starting the server. For SQL statements used to create, alter, and drop events, see Section 27.4.3, “Event Syntax”. Events are executed by a special event ...