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/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. FROM is a consistent read, reading ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
C applications can use character set autodetection based on the OS setting by invoking mysql_options() as follows before connecting to the server: mysql_options(mysql, MYSQL_SET_CHARSET_NAME, MYSQL_AUTODETECT_CHARSET_NAME); Each client supports a ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
For example, a column specified as SET('one', 'two') NOT NULL can have any of these values: '' 'one' 'two' 'one,two' A SET column can have a maximum of 64 distinct members. See String Type Storage Requirements for storage requirements for the SET ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. This section discusses the procedure for adding a character set to MySQL. The proper procedure depends on whether the character set is simple or complex: If the character ...If the character set needs either of those features, it is ...To use the ...
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
Transaction Characteristic Scope You can set transaction characteristics globally, for the current session, or for the next transaction only: With the GLOBAL keyword: The statement applies globally for all subsequent sessions. The default is OFF ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
For example, on Windows, you can set the USER variable to specify your MySQL account name. To do so, use this syntax: SET USER=your_name The syntax on Unix depends on your shell. To set a variable permanently, you can set it in a startup file or by ... Environment variables can be set at the command prompt to affect the current invocation of your command processor, or set permanently to affect future ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
Many Windows users find that a Microsoft character set, such as cp932 for Japanese Windows, is suitable. Sometimes adding or changing a <meta> tag suffices to correct the problem: for example, to insure that the user agent interprets page content as ...For example, the gb18030 character set is not supported prior to MySQL ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. utf16: The UTF-16 encoding for the Unicode character set using two or four bytes per character. utf32: The UTF-32 encoding for the ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Setting the binary logging format does not activate binary logging for the server. Changing the session binlog_format value requires privileges sufficient to set restricted session system variables. There are several reasons why a client might want ... You can select the binary logging format explicitly by starting the MySQL server with ...In MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/set-statement.html
Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement: SET PASSWORD assigns account passwords. Descriptions for those forms that are not associated with a specific server ...