PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Note Within all stored programs, the parser treats BEGIN [WORK] as the beginning of a BEGIN ... A ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
If you use a binary column to store information in multiple character sets, MySQL has no way to know which values use which character set and cannot convert the data properly. To remove these bytes, use the TRIM() function: UPDATE t SET col1 = ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
The group_replication_recovery channel could then be inadvertently started with the stored credentials, on either the original member or members that were cloned from it. An automatic start of Group Replication on server boot (including after a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
The debug information is stored in the GCS_DEBUG_TRACE file in the data directory. For details of the situation in which you might need to force a new group membership, and a procedure to follow when using this system variable, see Section 20.7.8, ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
On Windows, InnoDB always stores database and table names internally in lowercase. If the floating-point formats differ but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: simply copy the relevant files.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-multiple-nodes.html
Stored procedures, stored functions, triggers, and scheduled events are all supported by tables using the NDB storage engine, but these do not propagate automatically between MySQL Servers acting as Cluster SQL nodes, and must be re-created ...The ...A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html
If the trigger needs multiple result values from the code, you can put the code in a stored procedure and return the values using OUT parameters. For each table that has multiple triggers per combination of trigger event and action time, convert ...
https://dev.mysql.com/doc/refman/8.0/en/return.html
This statement is not used in stored procedures, triggers, or events. RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a ...
https://dev.mysql.com/doc/refman/8.0/en/sql-compound-statements.html
END compound statement and other statements that can be used in the body of stored programs: Stored procedures and functions, triggers, and events. These objects are defined in terms of SQL code that is stored on the server for later invocation (see ...A compound statement is a block that can contain other blocks; declarations for variables, condition handlers, and cursors; and flow control constructs such as loops and conditional ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. You should never alter the structure of tables in the mysql database in any manner whatsoever except by means of the procedure that is described in Chapter 3, Upgrading MySQL. To ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...