PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. The creator of a routine is the account used to execute the CREATE statement for it. This privilege is granted ...The ALTER ROUTINE privilege is needed to alter or drop stored ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
The configuration directory used by keyring_okv as the location for its support files should have a restrictive mode and be accessible only to the account used to run the MySQL server. The following procedure briefly summarizes the process of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
--connections=# Command-Line Format --connections=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 Number of cluster connections to create. --resume Command-Line Format --resume If a job is aborted (due to a temporary db error ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category.
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Masking functions provide strict and relaxed masking of Primary Account Numbers. Because it cannot be guaranteed that the number generated is not assigned to a legitimate payment account, the result of gen_rnd_pan() should never be displayed, other ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 6.5.2, “Installing or Uninstalling MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. This option tells MySQL not to trust the information in the .MYI file header and to re-create it using information from ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
In addition, you cannot use FOR UPDATE as part of the SELECT in a statement such as CREATE TABLE new_table SELECT ... (If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being ...
https://dev.mysql.com/doc/refman/5.7/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. By ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-show-tables.html
By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as well. --type, -t Can be used to restrict the output to one type of object, specified ... ndb_show_tables displays a list of all NDB database objects in the ...