PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
Use of an explicit MATCH clause does not have the specified effect, and it causes ON DELETE and ON UPDATE clauses to be ignored. For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-update.html
The result is that col1 and col2 have the same value. If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The second assignment in the following statement sets col2 to the current ...
https://dev.mysql.com/doc/refman/8.0/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/8.0/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI with MySQL, install the following: The DBI module. Optionally, the DBD ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The AUTO_INCREMENT column can have either a unique or nonunique index. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
The plugin ignores files that have been renamed manually and do not match the pattern, and files that were encrypted with a password no longer available in the keyring. The audit log plugin supports functions that provide an SQL interface for ...
https://dev.mysql.com/doc/refman/8.0/en/automatic-start.html
This section discusses methods for starting and stopping the MySQL server. Generally, you start the mysqld server in one of these ways: Invoke mysqld directly. On Windows, you can set up a MySQL service that runs automatically when Windows starts.
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-summary.html
If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement). In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type are: STATEMENT causes logging to be statement based. Setting the binary logging format does not activate ...