PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. The ARCHIVE storage engine produces special-purpose tables that ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users who have privileges for that database. A user can be assigned only one ...Unless those objects are installed, the audit_log plugin operates in legacy ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. INDEX_SCHEMA The name of the schema (database) to which the index belongs. The MySQL column list is similar to what SQL Server 2000 returns for ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
This script installs the innodb_memcache database with three required tables (cache_policies, config_options, and containers). It also installs the demo_test sample table in the test database. daemon_memcached_w_batch_size: Defines the batch commit ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
Log files contain all statements that made any changes, so they can be used to audit the database. Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based replication. Note ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
You can refer to a table within the default database as tbl_name, or as db_name.tbl_name to specify a database explicitly. Such a table produces a single row, is read during the optimization phase of query execution, and references to its columns ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. Using prepared ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
The binary log contains information about SQL statements that modify database contents. These events bring databases up to date from the point of the backup. Instead, each reference to a local variable is replaced by this construct for logging ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
For INSERT, REPLACE, and UPDATE, if a generated column is inserted into, replaced, or updated explicitly, the only permitted value is DEFAULT. Values of a generated column are computed from an expression included in the column definition. Generated ...