PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/drop-trigger.html
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. Use IF EXISTS to prevent an error from occurring for a trigger that does not exist. A NOTE is generated for a nonexistent trigger when using IF EXISTS. If the ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
An error occurs if you try to drop an account that does not exist. If the IF EXISTS clause is given, the statement produces a warning for each named user that does not exist, rather than an error. The DROP USER statement removes one or more MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
When creating a general tablespace outside of the data directory, the directory must exist prior to creating the tablespace. General Tablespace Row Format Support General tablespaces support all table row formats (REDUNDANT, COMPACT, DYNAMIC, ... A ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
With the default setting OFF, servers are not permitted to join a replication group if they have a lower major version than the existing group members. Warning Setting this option to ON does not make the new member compatible with the group, and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
mysql> CREATE TABLE t1 (c1 INT) ENCRYPTION='Y'; To enable encryption for an existing file-per-table tablespace, specify the ENCRYPTION option in an ALTER TABLE statement. mysql> SELECT SPACE, NAME, SPACE_TYPE FROM ...About Data-at-Rest Encryption ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-tuning.html
For existence checking, you typically only store a very # short value such as "1". Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html
This is the innodb_data_file_path setting after modifying the size attribute to reflect the current data file size, and after specifying a new 50MB auto-extending data file: innodb_data_home_dir = innodb_data_file_path = ... The system tablespace is ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
Return value: Returns the key value as a string for success, NULL if the key does not exist, or NULL and an error for failure. Return value: Returns the key length in bytes as an integer for success, NULL if the key does not exist, or NULL and an ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
With IGNORE, new rows that duplicate an existing row on a unique key value are discarded. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO Statement”.) To write data from a table ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-data-directories.html
Copy an Existing Data Directory With this method, any MySQL accounts or user data present in the data directory are carried over to the new data directory. Copy the my.cnf or my.ini option file used by the existing instance. Each MySQL Instance on ...