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/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. For additional information about some of the expression terms, see Expression ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
You can obtain information about existing stored procedures using the ROUTINES table in the INFORMATION_SCHEMA database (see Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”). For a database named dbname, use this query on the ...Where ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-triggers.html
Information about triggers can be obtained by querying the INFORMATION_SCHEMA.TRIGGERS table. You can obtain a listing of all triggers defined on database dbname using a query on the INFORMATION_SCHEMA.TRIGGERS table such as the one shown here: ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
The format of the CREATE SERVER statement is: CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) The server_name is used in the connection string when creating a new FEDERATED table. For more information on ... If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the CONNECTION ...
https://dev.mysql.com/doc/refman/8.0/en/functions.html
For information about loadable functions and stored functions, see Section 7.7, “MySQL Server Loadable Functions”, and Section 27.2, “Using Stored Routines”. Rather than showing examples in this format: mysql> SELECT MOD(29,9); +-----------+ ... Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkb-functions.html
For a description of WKB format, see Well-Known Binary (WKB) Format. These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier (SRID). Functions in this ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
Each account name uses the format described in Section 8.2.4, “Specifying Account Names”. Each role name uses the format described in Section 8.2.5, “Specifying Role Names”. Important Under some circumstances, GRANT may be recorded in server ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
See Section 19.1.3.1, “GTID Format and Storage” for a definition of GTID sets. For more information, see Section 19.1.3, “Replication with Global Transaction Identifiers”. GTID sets used with this function are represented as strings and so ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
If you are using row-based or mixed-format replication, all of the auto-increment lock modes are safe, since row-based replication is not sensitive to the order of execution of the SQL statements (and the mixed format uses row-based replication for ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benefits.html
This cache applies to many types of information and speeds up processing. The storage layout for table data is more efficient for BLOB and long text fields, with the DYNAMIC row format. You can monitor the internal workings of the storage engine by ... InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the ...