Search Results
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-snippets.html
The My Snippets option stores custom snippets in a file under the MySQL Workbench user's configuration directory. Using Snippets Snippets can be inserted into the SQL editor or the system's clipboard. Figure 8.7 SQL Snippets: Usage Local Snippets ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage ...
https://dev.mysql.com/doc/x-devapi-userguide/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. An SqlResult combines a result set produced by, for example, ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
This section provides configuration options that affect the SQL editor functionality in MySQL Workbench. Permits saving and reloading the SQL editor tabs after MySQL Workbench is closed and reopened (including after an unexpected shutdown). Scripts ...Auto-save scripts interval: [ 10 seconds ] Frequency of the automatic ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-log-sql.html
You can log all SQL statements executed by MySQL Shell commands or utilities to the MySQL Shell log file. Note logSql replaces dba.logSql if dba.logSql is disabled, logSql takes precedence. However, if dba.logSql is enabled, it takes precedence ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-sql-system-log.html
SQL statements that you issue in MySQL Shell’s SQL mode can be sent to the operating system’s system logging facility. When you activate system logging for SQL statements, the following items are written to the system logging facility: SQL ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-toolbar.html
The SQL query toolbar provides actions that enable you to create and manage queries. The following figure shows the set buttons in the toolbar, located within the SQL query tab. Figure 8.3 SQL Query Toolbar SQL query tools (from left to right) are: ...Execute the selected portion of the script or everything, if there is no selection: Provides a simple way to execute the entire query or a subset of the ...
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Use the value binding syntax of Session.sql() instead; see Section 2.4, “Using SQL with Session” for some examples. C++ Code #include <mysqlx/xdevapi.h> // Note: The following ...