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/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view. Indexes can be used for views processed using the merge algorithm. However, a ...
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Required credentials for clients that connect to the MySQL server can include a password. MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD ...
https://dev.mysql.com/doc/refman/8.0/en/channels-naming-conventions.html
This section describes how naming conventions are impacted by replication channels. Each replication channel has a unique name which is a string with a maximum length of 64 characters and is case-insensitive. Because channel names are used in the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); Both the UNICODE attribute and the ucs2 character set are deprecated in MySQL 8.0.28.