PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=path Type String Default Value [none] The directory where character sets are installed. --debug[=debug_options], -# [debug_options] Command-Line Format --debug[=debug_options] ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-disabling.html
The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example: SET GLOBAL audit_log_disable = true; Setting audit_log_disable to true disables the audit ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Use of multiple statements requires that a client is able to send statement strings containing the ; ...A compound statement can contain multiple statements, enclosed by the BEGIN and END ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. To remove these bytes, use the TRIM() function: UPDATE t SET col1 = TRIM(TRAILING 0x00 FROM col1); Suppose that table t has a nonbinary column named ...For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're converting the column ...
https://dev.mysql.com/doc/refman/5.7/en/charset.html
The default MySQL server character set and collation are latin1 and latin1_swedish_ci, but you can specify character sets at the server, database, table, column, and string literal levels. MySQL includes character set support that enables you to ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
Instead, the table definition includes a connection string that points to the remote table. The local server communicates with the remote server using MySQL client C API functions. When you create a table using one of the standard storage engines ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
The full-text search syntax described in Section 12.9, “Full-Text Search Functions” applies to the MeCab parser plugin. The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
That is true for names of cursors, conditions, procedures, functions, savepoints, stored routine parameters, stored program local variables, and plugins. File system case sensitivity can affect searches in string columns of INFORMATION_SCHEMA tables. In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
Some APIs also offer separate special transaction commit and rollback functions or methods. If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with ...