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/binary-log-mixed.html
When the body of a view requires row-based replication, the statement creating the view also uses it. For example, this occurs when the statement creating a view uses the UUID() function. When running in MIXED logging format, the server ...
https://dev.mysql.com/doc/refman/8.0/en/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. Stored procedures that take no arguments can be invoked without parentheses. CALL can pass back values ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
Note: Undoing the above should be as simple as deleting the registry entries you've created. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing ...
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.
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html
For example: CREATE TABLE t (s1 CHAR(1)) CHARACTER SET utf8mb3; SELECT * FROM t WHERE s1 COLLATE utf8mb3_general_ci = 'x'; DECLARE x VARCHAR(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_danish_ci; SELECT CAST('a' AS CHAR CHARACTER SET utf8mb4) COLLATE ... The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
With FOR UPGRADE, the server checks each table to determine whether there have been any incompatible changes in any of the table's data types or indexes since the table was created. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED ...
https://dev.mysql.com/doc/refman/8.0/en/clone.html
The MySQL server requires the necessary write access to create the specified directory. The MySQL server must have the necessary write access to create the directory. CLONE clone_action clone_action: { LOCAL DATA DIRECTORY [=] 'clone_dir'; | ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
Normally, the build process does not need to create sql_yacc.cc because MySQL comes with a pregenerated copy. However, if you do need to re-create it, you might encounter this error: "sql_yacc.yy", line xxx fatal: default action causes potential...