PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
managed_type: The type of managed service that the asynchronous connection failover mechanism must provide for this server. The following functions, which are available from MySQL 8.0.22 for standard source to replica replication and from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/return.html
There must be at least one RETURN statement in a stored function. RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There may be more than one if the function has multiple ...This statement is not used in stored procedures, triggers, or ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.
https://dev.mysql.com/doc/refman/8.0/en/set-default-role.html
role [, role ] ...: Set the default to the named roles, which must exist and be granted to the account at the time SET DEFAULT ROLE is executed. For each user named immediately after the TO keyword, this statement defines which roles become active ... SET DEFAULT ROLE {NONE | ALL | role [, role ] ...} TO user [, user ] ...
https://dev.mysql.com/doc/refman/8.0/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html
row *************************** Function: hello sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Function: CREATE DEFINER=`me`@`localhost` FUNCTION `hello`(s ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, or have the SELECT privilege at the global level. It displays a representation of the internal implementation of the named stored procedure.
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. To use either statement, you must be the user named as the routine DEFINER, have the ...The ... SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-defining.html
By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server. For example, the following stored procedure has a ... Each stored program contains a body that consists of an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. is the outer query (or outer statement), and (SELECT column1 FROM t2) is the subquery. We say that the subquery is ...