PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/case.html
[ELSE statement_list] END CASE Or: CASE WHEN search_condition THEN statement_list [WHEN search_condition THEN statement_list] ... This value is compared to the when_value expression in each WHEN clause until one of them is equal. This syntax cannot ... CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ...
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 ...