Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-vb.html
5.6.7.1.1 ADO: rs.addNew, rs.delete, and rs.update The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
Partial Updates of JSON Values In MySQL 8.4, the optimizer can perform a partial, in-place update of a JSON column instead of removing the old document and writing the new document in its entirety to the column. This optimization can be performed ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-status-system-variables.html
The st_mysql_sys_var structure is defined as follows: struct st_mysql_sys_var { int flags; const char *name, *comment; int (*check)(THD*, struct st_mysql_sys_var *, void*, st_mysql_value*); void (*update)(THD*, struct st_mysql_sys_var *, void*, ...
A Quick Guide to Using the MySQL SLES Repository :: A Quick Guide to Using the MySQL SLES Repository
https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/index.html
Although this is not required for each update, it does update MySQL repository information to include the current information. Among other instructions discussed there, it is especially important to back up your database before the update. To update ... Abstract This is a quick guide for using the MySQL SLES repository to install and upgrade MySQL on SUSE Linux Enterprise Server ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
Locks may be used to emulate transactions or to get more speed when updating tables. For cascading updates, a shared-nothing write lock (LOCK TABLES WRITE) is taken on related tables that are involved in the operation. WRITE locks normally have ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
What is the default server SQL mode when MySQL 8.4 is installed? A.3.1. What are server SQL modes? Server SQL modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. How many server SQL modes are ...This makes it easier to use MySQL in different environments and to use MySQL together with other database ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
It is possible to grant privileges that apply globally if the partial_revokes system variable is enabled. Specifically, for users who have privileges at the global level, partial_revokes enables privileges for specific schemas to be revoked while ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
SELECT (for table referenced in REPLACE clause LOAD DATA LOAD XML update event: UPDATE UPDATE ... WHERE (for tables referenced in UPDATE clause) Blocking Execution of Specific Events event items can include an abort item that indicates whether to ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
--idempotent Command-Line Format --idempotent Type Boolean Default Value true Tell the MySQL Server to use idempotent mode while processing updates; this causes suppression of any duplicate-key or key-not-found errors that the server encounters in ...mysqlbinlog sets the value of pseudo_replica_mode to true before executing any SQL ... The server's binary log ...