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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
Nullpos, Nullbit For columns that can be NULL, MyISAM stores NULL values as a flag in a byte. The position and number of bytes used to store NULL flags is shown in the line for field 1. no endspace, not_always Do not store endspace and do not do ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
FileSystemPath: Path to directory where data node stores its data (directory must exist). FileSystemPathDataFiles: Path to directory where data node stores its Disk Data files. FileSystemPathDD: Path to directory where data node stores its Disk Data ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
By default, audit log filter definitions are stored in the mysql system database, and you can display audit filters by querying the mysql.audit_log_filter table. To grant one of these privileges to a user account, use this statement: GRANT privilege ... Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be needed. Note If you use ALTER DATABASE to change the database default character set or collation, ...If applications require data storage using a different character set or collation, you can configure character set information several ways: Specify character settings per ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
You can also store InnoDB tables in a shared general tablespace, which support multiple tables and all row formats. If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Variables (system variables, user-defined variables, and stored program local variables) are not permitted. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ...