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/triggers.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. The following sections describe the syntax for creating and dropping triggers, show some examples of how to use ...Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
For example, for the MyISAM tables in the mysql database, there must be no administrative changes to MySQL accounts during the backup. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is metadata. Thus column names, database names, user names, version names, and most of the string results from SHOW ...Representation of metadata must satisfy these requirements: All metadata must be in the same character ...
https://dev.mysql.com/doc/refman/8.0/en/compatibility.html
We continue to support transactional and nontransactional databases to satisfy both mission-critical 24/7 usage and heavy Web or logging usage. MySQL Server was originally designed to work with medium-sized databases (10-100 million rows, or about ... This section describes how MySQL relates to the ANSI/ISO SQL ...
https://dev.mysql.com/doc/refman/8.0/en/connectors-apis.html
Connector/J provides driver support for connecting to MySQL from Java applications using the standard Java Database Connectivity (JDBC) API. Connector/ODBC provides driver support for connecting to MySQL using the Open Database Connectivity (ODBC) ... MySQL Connectors provide connectivity to the MySQL server for client ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
The connection string specifies the server name, login credentials, port number and database/table information. To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). Before querying it, set the value of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). Before querying it, set the value of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
Data is stored in a MySQL database to protect against crashes, outages, and corruption. The direct, low-level database access path used by the daemon_memcached plugin is much more efficient for key-value lookups than equivalent SQL queries. The ...