Search Results
https://dev.mysql.com/doc/refman/8.4/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. MySQL provides ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
The JSON_TABLE() function generates a table and provides another way to create a derived table: SELECT * FROM JSON_TABLE(arg_list) [AS] tbl_name ... This can occur if the outer query accesses any tables and an inner query invokes a stored function ...For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
You can retrieve the most recent automatically generated AUTO_INCREMENT value with the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API function. These functions are connection-specific, so their return values are not affected by another ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
If the value is func, the value used is the result of some function. To see which function, use SHOW WARNINGS following EXPLAIN to see the extended EXPLAIN output. The function might actually be an operator such as an arithmetic operator. The ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values. ON DUPLICATE KEY UPDATE inserts or updates a row, ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-plugin-installation.html
If you intend to use keyring functions in conjunction with the chosen keyring component or plugin, install the functions after installing that component or plugin, using the instructions in Section 8.4.4.12, “General-Purpose Keyring Key-Management ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring plugin, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
Each row in this table corresponds to a table being replicated, determines how to log changes to the table and, if a conflict resolution function is specified, and determines how to resolve conflicts for that table. conflict_fn column The conflict ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Installing Plugins Controlling Plugin Activation State Uninstalling Plugins Plugins and Loadable Functions Installing Plugins Before a server plugin can be used, it must be installed using one of the following methods. Plugins and Loadable Functions ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids.html
The auto-positioning function for synchronizing a replica and source that use GTIDs (see Section 19.1.3.3, “GTID Auto-Positioning”). Stored functions that you can use to work with GTIDs (see Section 19.1.3.8, “Stored Function Examples to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...