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/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. For information about the differences between the binary collation of the binary character set and the _bin collations of nonbinary character sets, see ...Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from numeric byte ...
https://dev.mysql.com/doc/refman/5.7/en/charset-asian-sets.html
For example, the Chinese sets must allow for thousands of different characters. See Section 10.10.7.1, “The cp932 Character Set”, for additional information about the cp932 and sjis character sets. See Section 10.10.7.2, “The gb18030 Character ... The Asian character sets that we support include Chinese, Japanese, Korean, and ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engine-setting.html
You can set the default storage engine for the current session by setting the default_storage_engine variable: SET default_storage_engine=NDBCLUSTER; The storage engine for TEMPORARY tables created with CREATE TEMPORARY TABLE can be set separately ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/5.7/en/show-character-set.html
The filename character set is for internal use only; consequently, SHOW CHARACTER SET does not display it. Character set information is also available from the INFORMATION_SCHEMA CHARACTER_SETS table. SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name or -DWITH_EXTRA_CHARSETS=charset_name ...
https://dev.mysql.com/doc/refman/5.7/en/set-names.html
Setting character_set_connection to charset_name also sets collation_connection to the default collation for charset_name. If given, the collation must one of the permitted collations for charset_name. SET NAMES {'charset_name' [COLLATE ...The ...
https://dev.mysql.com/doc/refman/5.7/en/charset-we-sets.html
Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and English. ascii ...The latin1_swedish_ci collation is the default that probably is used by the majority of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Set innodb_ft_user_stopword_table to the name of the table containing a list of stopwords, in the format db_name/table_name. The setpriority() system call is used on Linux platforms where it is supported, and where the mysqld execution user is ...
https://dev.mysql.com/doc/refman/5.7/en/set-global-sql-slave-skip-counter.html
SET GLOBAL sql_slave_skip_counter = N This statement skips the next N events from the master. This is useful for recovering from replication stops caused by a statement. For nontransactional tables, an event group corresponds to a single SQL ...