PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html
X Plugin extends MySQL Server to be able to function as a document store. Running X Plugin enables MySQL Server to communicate with clients using the X Protocol, which is designed to expose the ACID compliant storage abilities of MySQL as a document ... MySQL supports an plugin API that enables creation of server ...
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
For example: ALTER USER user IDENTIFIED BY 'auth_string'; Note Clauses for random password generation, password verification, and secondary passwords apply only to accounts that use an authentication plugin that stores credentials internally to ...
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
The value is YES if NULL values can be stored in the column, NO if not. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html
No matter how you write out a view definition, MySQL always stores it the same way, in a canonical form. SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
delete_flag is 0 for dynamic tables because the flag is stored in the dynamic row header. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of the three MyISAM storage formats, static format is the ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
MySQL may store a table's index and data in one or more other files, depending on the storage engine. Table and column definitions are stored in the MySQL data dictionary. When you create a new table, you can specify which storage engine to use by ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-table-problems.html
It may occur for temporary tables created outside stored functions and referred to across multiple calling and callee functions. Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported ...
https://dev.mysql.com/doc/refman/8.0/en/time.html
In particular, any fractional part in a value inserted into a TIME column is stored rather than discarded. Note that because '00:00:00' is itself a valid TIME value, there is no way to tell, from a value of '00:00:00' stored in a table, whether the ... MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-memory-usage.html
Each stored trace is a string, which is extended (using realloc()) as optimization progresses by appending more data to it. The optimizer_trace_max_mem_size server system variable sets a limit on the total amount of memory used by all traces ...If ...
https://dev.mysql.com/doc/refman/8.0/en/triggers.html
There are some restrictions on the use of triggers; see Section 27.8, “Restrictions on Stored Programs”. Binary logging for triggers takes place as described in Section 27.7, “Stored Program Binary Logging”. A trigger is a named database ...