Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-statement.html
Syntax: str = cursor.statement This read-only property returns the last executed statement as a string. The statement property can be useful for debugging and displaying what was sent to the MySQL server. The string can contain multiple statements ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-prepared-statements.html
Default Value true Since Version 3.1.12 useServerPrepStmts Use server-side prepared statements if the server supports them? The server may limit the number of prepared statements with 'max_prepared_stmt_count' or disable them altogether. In case of ...
https://dev.mysql.com/doc/refman/8.4/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/internals/en/unsafe-statements.html
An unsafe statement will be logged in row format if binlog_format=MIXED and will generate a warning if binlog_format=STATEMENT. The following types of sub-statements are currently marked unsafe: System functions that may return a different value on ... NOTE: the following list is incomplete; it does not take into account changes made in 2010 or later ...
https://dev.mysql.com/doc/refman/8.4/en/set-statement.html
See Section 15.7.6.2, “SET CHARACTER SET Statement”, and Section 15.7.6.3, “SET NAMES Statement”. Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement: SET DEFAULT ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-statements.html
Default Value true Since Version 8.0.20 continueBatchOnError Should the driver continue processing batch commands if one statement fails. Default Value true Since Version 3.0.3 dontTrackOpenResources The JDBC specification requires the driver to ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-statements.html
Default Value true Since Version 8.0.20 continueBatchOnError Should the driver continue processing batch commands if one statement fails. Default Value true Since Version 3.0.3 dontTrackOpenResources The JDBC specification requires the driver to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-replica.html
Section 15.4.1, “SQL Statements for Controlling Source Servers”, discusses statements for managing source servers. In addition to the statements described here, SHOW REPLICA STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-source.html
Section 15.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-problems.html
Here follows a list of the currently known problems with prepared statements: TIME, TIMESTAMP, and DATETIME do not support parts of seconds (for example, from DATE_FORMAT()). When converting an integer to string, ZEROFILL is honored with prepared ...When converting a floating-point number to a string in the client, the rightmost digits of the converted value may differ slightly from those of the original ...