Search Results
https://dev.mysql.com/doc/internals/en/error-messages-old-versions.html
In practice, no new error messages should be added to error message files for versions of MySQL prior to 5.0.3. Before MySQL 5.0.3, error messages are stored in errmsg.txt files in the language directories under sql/share. For each new error ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/method-chaining.html
This section explains how to use method chaining instead of working with SQL strings of JSON structures. The following example shows how method chaining is used instead of an SQL string when working with Session objects. // New method chaining used ... X DevAPI supports a number of modern practices to make working with CRUD operations easier and to fit naturally into modern development ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/method-chaining.html
This section explains how to use method chaining instead of working with SQL strings of JSON structures. The following example shows how method chaining is used instead of an SQL string when working with Session objects. X DevAPI supports a number ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Where can I find the ANSI SQL 2003 specification for stored procedures? A.4.5. Is there a MySQL equivalent to using mod_plsql as a gateway on Apache to talk ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-error-handling.html
If you run out of file space in a tablespace, a MySQL Table is full error occurs and InnoDB rolls back the SQL statement. A duplicate-key error rolls back the SQL statement, if you have not specified the IGNORE option in your statement. Other errors ...InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...If a statement returns an error, the commit or rollback behavior depends on the ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ... In the WHERE expression, you can use any of the ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...Two functions providing basic XPath 1.0 (XML Path Language, version 1.0) capabilities are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
As of MySQL 9.4.1, you can load data from Object Storage by using event-based incremental load. This feature is currently only available for MySQL HeatWave on OCI. When setting up event-based incremental load, you specify the stream OCID in each ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
This section explains the configuration settings required for MySQL Server instances that you want to use for Group Replication. Set the disabled_storage_engines system variable as follows to prevent their use: ...Storage Engines Replication ...