Search Results
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
SQL syntax for prepared statements can be used within stored procedures, but not in stored functions or triggers. To write C programs that use the CALL SQL statement to execute stored procedures that contain prepared statements, the ...Using ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
On Windows, compile loadable functions using the following procedure: Obtain a MySQL source distribution. To remove functions, use DROP FUNCTION: DROP FUNCTION metaphon; DROP FUNCTION myfunc_double; DROP FUNCTION myfunc_int; DROP FUNCTION sequence; ... The MySQL interface for loadable functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Any data that was stored in the dropped ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
[WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name DROP HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Note The rules table is loaded into the plugin by the flush_rewrite_rules stored procedure. Unless that procedure has been called following the most recent table modification, the table contents do not necessarily correspond to the set of rules the ...Users communicate with the plugin by modifying the set of rules stored in this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
innodb_background_drop_list_empty Command-Line Format --innodb-background-drop-list-empty[={OFF|ON}] System Variable innodb_background_drop_list_empty Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF Enabling the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
ALTER USER Multifactor Authentication Options ALTER USER has ADD, MODIFY, and DROP clauses that enable authentication factors to be added, modified, or dropped. When ALTER USER adds, modifies, or drops second and third factors in a single statement, ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
The functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the functions. MySQL Enterprise Encryption functions are provided by the MySQL component_enterprise_encryption component.
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
job_mysql: Connects to a MySQL server to perform operations such as queries and stored procedures. Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating ...