PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/xa.html
The MySQL XA implementation is based on the X/Open CAE document Distributed Transaction Processing: The XA Specification. The XA interface to a MySQL server consists of SQL statements that begin with the XA keyword. MySQL client programs must be ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
If you refer to a temporary table multiple times in a stored function under different aliases, a Can't reopen table: 'tbl_name' error occurs, even if the references occur in different statements within the function. Unsupported Syntax from the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
However, column c2 uses in-memory storage, as can be seen here in the output of SHOW CREATE TABLE: mysql> SHOW CREATE TABLE t3\G *************************** 1. For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change the storage type of an individual column, you can use ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
MySQL checks foreign key constraints immediately; the check is not deferred to transaction commit. MySQL essentially implements the semantics defined by MATCH SIMPLE, which permits a foreign key to be all or partially NULL. (It is possible to ...For ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
More generally, MySQL uses the concept of character set repertoire, which can sometimes be used to determine subset relationships among character sets and enable conversion of operands in operations that would otherwise produce an error. In the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-we-sets.html
ascii (US ASCII) collations: ascii_bin ascii_general_ci (default) cp850 (DOS West European) collations: cp850_bin cp850_general_ci (default) dec8 (DEC Western European) collations: dec8_bin dec8_swedish_ci (default) The dec character set is ...
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... It can take the following forms: mysql_error_code: ...HANDLER statement specifies a handler that deals with one or more ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, must be specified to drop an undo tablespace. mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 Engine=InnoDB; mysql> DROP ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. The following discussion covers the Event Scheduler and is divided into the following sections: Section 27.4.1, “Event ...