Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
Warnings Altering the session time zone affects the results of MySQL functions such as NOW(), CURTIME(), or CURDATE()—if you do not want those functions to be affected, do not use this setting. Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. Additional functionality includes the ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ALTER statements for stored programs, triggers, views, and loadable functions. Where applicable: The state of data dictionary, routine, event, and loadable ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...
https://dev.mysql.com/doc/refman/8.4/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. This section describes ...
https://dev.mysql.com/doc/refman/8.4/en/component-loading.html
A component when installed may also automatically install related loadable functions. If so, the component when uninstalled also automatically uninstalls those functions. Components must be loaded into the server before they can be used. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/connectors-apis.html
Connector/NET implements a fully functional ADO.NET interface and provides support for use with ADO.NET aware tools. Native drivers are fast, as there is less copying of data between components, and they can offer advanced functionality not ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin.html
A set of loadable functions provides an SQL-level API for performing masking and de-identification operations. MySQL Enterprise Data Masking and De-Identification is based on a plugin library that implements these elements: A server-side plugin ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-server.html
If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe functionality). If mysqld does not want to start, verify that you have no my.cnf files ...