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/audit-log-file-formats.html
When the audit log plugin begins writing a new log file, it writes the XML declaration and opening <AUDIT> root element tag. When the audit log plugin begins writing a new log file, it writes the XML declaration and opening <AUDIT> root element tag.
https://dev.mysql.com/doc/refman/8.0/en/char.html
The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. The length of a CHAR column is fixed to the length that you declare when you create the table. The CHAR and VARCHAR types are ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Declare the PRIMARY KEY clause in the original CREATE TABLE statement, rather than adding it later through an ALTER TABLE statement. If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The event does ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
If the constraint expression evaluates to a data type that differs from the declared column type, implicit coercion to the declared type occurs according to the usual MySQL type-conversion rules. Prior to MySQL 8.0.16, CREATE TABLE permits only the ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
Declare columns with identical information in different tables with identical data types, to speed up joins based on the corresponding columns. Design your tables to minimize their space on the disk. This can result in huge improvements by reducing ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
If an ENUM column is declared to permit NULL, the NULL value is a valid value for the column, and the default value is NULL. If an ENUM column is declared NOT NULL, its default value is the first element of the list of permitted values. An ENUM is ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
For either condition, you can avoid having the warnings be logged by declaring a condition handler; see Section 15.6.7.2, “DECLARE ... The Event Scheduler writes information about event execution that terminates with an error or warning to the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Declaring stored functions to be DETERMINISTIC or setting the log_bin_trust_function_creators system variable to 0 keeps random operations producing random values from being invoked. Where can I find documentation for MySQL stored procedures and ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Declaring a NOT NULL constraint on a column provides reassurance that there are no rows left out of the index, allowing for better query optimization (accurate counting of rows and estimation of whether to use the index). For example, if a value is ... These terms are commonly used in information about the MySQL database ...