PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-create-function.html
SHOW CREATE FUNCTION func_name This statement is similar to SHOW CREATE PROCEDURE but for stored functions.
https://dev.mysql.com/doc/refman/8.0/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files.html
The following discussion describes how to create the files required for SSL and RSA support in MySQL. File creation can be performed using facilities provided by MySQL itself, or by invoking the openssl command directly. SSL certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/refman/8.0/en/ldml-rules.html
Table 12.5 Abbreviated Shift Syntax Abbreviated Syntax Nonabbreviated Syntax <pc>xyz</pc> <p>x</p><p>y</p><p>z</p> <sc>xyz</sc> <s>x</s><s>y</s><s>z</s> <tc>xyz</tc> <t>x</t><t>y</t><t>z</t> <ic>xyz</ic> <i>x</i><i>y</i><i>z</i> An expansion is a ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
CRUD Acronym for “create, read, update, delete”, a common sequence of operations in database applications. auto-increment A property of a table column (specified by the AUTO_INCREMENT keyword) that automatically adds an ascending sequence of ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
Within a string, certain sequences have special meaning unless the NO_BACKSLASH_ESCAPES SQL mode is enabled. Each of these sequences begins with a backslash (\), known as the escape character. MySQL recognizes the escape sequences shown in Table ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
The server creates a copy of the file in the directory where it stores temporary files. If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). In some extreme cases, you can create ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
For example, Create DB and Change user correspond to COM_CREATE_DB and COM_CHANGE_USER, respectively. The value is composed from a sequence number and timestamp, in the format SEQ_TIMESTAMP. When the audit log plugin opens the audit log file, it ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
If compression or encryption are enabled, the effective file name (the name actually used to create the log file) differs from the configured file name because it has additional suffixes: If compression is enabled, the plugin adds a suffix of .gz.