PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...
https://dev.mysql.com/doc/refman/9.7/en/kerberos-pluggable-authentication.html
Note Kerberos pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using Kerberos, ...
https://dev.mysql.com/doc/refman/9.7/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 9.7, through release 9.7.0. Differences between minor versions of MySQL 9.7 are noted in the present text with reference to release numbers (9.7.x). This manual is not intended for ...
https://dev.mysql.com/doc/refman/9.7/en/source-installation-doxygen.html
The MySQL source code contains internal documentation written using Doxygen. It is also possible to generate this content locally from a MySQL source distribution using the following procedure: Install doxygen 1.9.2 or later. After installing ...
https://dev.mysql.com/doc/refman/9.7/en/analyze-table.html
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body schedule: { AT timestamp [+ INTERVAL interval] ... The ...
https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html
By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...