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/adding-collation.html
The value that it returns to indicate weights is a binary string, so it is convenient to use HEX(WEIGHT_STRING(str)) to display the weights in printable form. A collation is a set of rules that defines how to compare and sort character strings.
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-update.html
If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. The ...
https://dev.mysql.com/doc/refman/5.7/en/arithmetic-functions.html
Table 12.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/5.7/en/assignment-operators.html
Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-elements.html
MySQL Enterprise Audit is based on the audit log plugin and related elements: A server-side plugin named audit_log examines auditable events and determines whether to write them to the audit log. Tables in the mysql system database provide ...A set ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log.html
The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access. Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a ...
https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
To convert a bit value to printable form, use it in numeric context or use a conversion function such as BIN() or HEX(). A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...