Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-create-library.html
This means that SHOW CREATE LIBRARY prints the source code of the library, and all libraries in the Information Schema libraries table are visible to this account. row *************************** Library: lib1 sql_mode: ... SHOW CREATE LIBRARY ...
https://dev.mysql.com/doc/refman/9.7/en/source-installation-layout.html
See Table 2.3, “MySQL Installation Layout for Generic Unix/Linux Binary Package”, and MySQL Installation Layout on Microsoft Windows. By default, when you install MySQL after compiling it from source, the installation step installs files under ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-simple-statements.html
A simple statement returns a result set which can be used to access data (rows), metadata, and diagnostic information. A simple statement is static, and cannot be modified after creation; in other words, it cannot be parametrized. A simple ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-management.html
The syntax of the routine body is checked at creation time; any errors cause the CREATE statement to be rejected, and the stored program not to be created. The program body must be demarcated using the AS keyword plus dollar-quoted delimiters such ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html
Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored function. getProcedure(): Get a Function instance given the name of a stored ...
https://dev.mysql.com/doc/refman/9.7/en/start-replica.html
Important The password that you set using START REPLICA is masked when it is written to MySQL Server’s logs, Performance Schema tables, and SHOW PROCESSLIST statements. START REPLICA [thread_types] [until_option] [connection_options] ...
https://dev.mysql.com/doc/refman/9.7/en/stop-group-replication.html
This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while ...
https://dev.mysql.com/doc/refman/9.7/en/stored-routines-privileges.html
The account thus has full access to the routine output as produced by: The contents of the Information Schema ROUTINES table. The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create ...
https://dev.mysql.com/doc/refman/9.7/en/string-functions-charset.html
In such expressions, the table character set is used for BIN_TO_UUID(), CONV(), or HEX() results, regardless of connection character set. MySQL has many operators and functions that return a string. This section answers the question: What is the ...
https://dev.mysql.com/doc/refman/9.7/en/string-functions.html
For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to the nearest integer. ASCII(str) Returns the numeric value of the leftmost character of ...