PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
On the source, you can control which databases to log changes for by using the --binlog-do-db and --binlog-ignore-db options to control binary logging. For a description of the rules that servers use in evaluating these options, see Section ... If a ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
The user table row for an account indicates the account privileges that apply on a global basis no matter what the default database is. For example, if the user table grants you the DELETE privilege, you can delete rows from any table in any ...
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 ...