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/channels-with-prev-replication.html
Warning Use RESET SLAVE with caution as this statement deletes all existing channels, purges their relay log files, and recreates only the default channel. In this case, error 1964 Multiple channels exist on the slave. When a replica has multiple ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
To override this, provide explicit CHARACTER SET and COLLATE table options. Every database has a database character set and a database collation. The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
This includes characters in the Basic Multilingual Plane (BMP) range (U+0000 to U+FFFF) and supplementary characters outside the BMP range (U+10000 to U+10FFFF). The repertoire of a character set is the collection of characters in the set. String ...
https://dev.mysql.com/doc/refman/5.7/en/corrupted-myisam-tables.html
If your tables become corrupted frequently, you should try to determine why this is happening. You can verify this easily by looking for a recent restarted mysqld message in the error log. Even though the MyISAM table format is very reliable (all ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. The ENGINE option is part of the CREATE TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
This means that two different sessions can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name. In this case, all subsequent references to the table must be qualified with ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
This section discusses the following topics: Creating Accounts and Granting Privileges Checking Account Privileges and Properties Revoking Account Privileges Dropping Accounts For additional information about the statements discussed here, see ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
The name of this file is the same as the name of the table with the extension CSM. If you examine the test.CSV file in the database directory created by executing the preceding statements, its contents should look like this: "1","record one" ... The ...
https://dev.mysql.com/doc/refman/5.7/en/drop-event.html
DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. You can override this and cause the statement to generate a warning for nonexistent events instead using IF EXISTS. This statement requires the EVENT privilege for ...The event immediately ceases being active, and is deleted completely from the ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
This occurs, for example, if a function does not support a specified algorithm, a key length is too short or long, or a string expected to be a key string in PEM format is not a valid key. Then this symmetric key identity relationship holds: ...