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/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. It differs from DELETE in the following ways: Truncate operations drop and re-create the table, which is much ...To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
(This constraint rules out the use of the keyring functions for manipulation of instance-wide keys, such as those created by InnoDB to support tablespace encryption.) To enable multiple users to perform operations on the same key, “wrapper” ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
A stored routine that uses the database defaults when the routine is created includes those defaults as part of its definition. See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. By default, triggers that have the same ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
When using a multithreaded replica (replica_parallel_workers > 0), stopping the replica can cause gaps in the sequence of transactions that have been executed from the relay log, regardless of whether the replica was stopped intentionally or ...] ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
Can I run NDB Cluster nodes inside virtual machines (such as those created by VMWare, VirtualBox, Parallels, or Xen)? A.10.13. You must also remember to account for any column indexes as follows: Each primary key or hash index created for an ... In ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
This occurs even when the function name is used in nonexpression context: mysql> CREATE TABLE count(i INT); ERROR 1064 (42000): You have an error in your SQL syntax ... To minimize the dependency of SQL code on the IGNORE_SPACE setting, use these ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
Instructions for creating any required certificate and key files are available in Section 8.3.3, “Creating SSL and RSA Certificates and Keys”. Should you need to create the required certificate and key files, see Section 8.3.3, “Creating SSL ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...