Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; For information about these forms of string syntax, see Section 12.3.7, “The National Character Set”, and Section 12.3.8, “Character Set ... A ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to reuse. Thus, this procedure is useful primarily for executing dynamic statements on a one-time ...Configuration Options execute_prepared_stmt() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 30.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ON, produce debugging ...
https://dev.mysql.com/doc/refman/8.4/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...This is done by setting the optimizer_trace_offset and optimizer_trace_limit system variables, like this: SET optimizer_trace_offset=offset, optimizer_trace_limit=limit; offset is a signed integer (default -1); limit is a positive integer (default ...
https://dev.mysql.com/doc/refman/8.4/en/windows-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica.html
(You can also leave the skip-replica-start entry in, but then you will always need to use the START REPLICA statement to start replication whenever you restart the replica server.) Restart the replica server. (You can also leave the ... MySQL ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
This section describes C API data structures other than those used for prepared statements, the asynchronous interface, or the replication stream interface. For information about those, see Section 6.2, “C API Prepared Statement Data ...Do not ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options.html
MYSQL_INIT_COMMAND (argument type: char *) SQL statement to execute when connecting to the MySQL server. It specifies the directory in which files named in LOAD DATA LOCAL statements must be located. MYSQL_REPORT_DATA_TRUNCATION (argument type: bool ... int mysql_options(MYSQL *mysql, enum mysql_option option, const void *arg) Description Can be used to set extra connect options and affect behavior for a ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-3-0.html
(Bug #35929119) When a CallableStatement was used to call a stored procedure or function that did not exist on the server or that the client had no rights to access its parameters' metadata, Connector/J tried to infer the parameter metadata from the ... Version 8.3.0 is a new GA release of MySQL ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #117579, Bug #37639722) The ResultSet.HOLD_CURSORS_OVER_COMMIT mode is now consistently supported across connections, statements, and result sets, which was not the case before this fix. (Bug #38044940) A java.sql.Time instance created from a ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
All indexes of a table (including the clustered index) are compressed using the same page size, as specified in the CREATE TABLE or ALTER TABLE statement. Table attributes such as ROW_FORMAT and KEY_BLOCK_SIZE are not part of the CREATE INDEX syntax ...Thus, compression applies only to tables (and indexes) stored in file-per-table or general ...