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/show-columns.html
SHOW [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given table. These two statements are equivalent: SHOW COLUMNS FROM mytable FROM mydb; ...SHOW COLUMNS displays information only for those columns for which you have some ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
Replicated statements executed on a replica are processed by the replica SQL thread, which has full privileges. It is possible for a procedure to follow different execution paths on source and replica servers, so a user can write a routine ... The ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
Is it possible to use FULLTEXT indexes with NDB Cluster? A.10.23. Is it possible to use FULLTEXT indexes with NDB Cluster? FULLTEXT indexing is currently supported only by the InnoDB and MyISAM storage engines. Some NDB Cluster users have ... In the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html
The change buffer is fully durable and can survive a system crash. A full merge of the change buffer can be forced as part of a slow server shutdown using --innodb-fast-shutdown=0. What types of operations modify secondary indexes and result in ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Designed to be fully multithreaded using kernel threads, to easily use multiple CPUs if they are available. Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
In terms of table structure, these are the primary potential incompatibilities: For the variable-length character data types (VARCHAR and the TEXT types), the maximum permitted length in characters is less for utf8mb4 columns than for utf8mb3 ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
This avoids potential problems with trailing space removal or character set conversion that would change data values, such as may occur if you use a nonbinary string data type (CHAR, VARCHAR, TEXT). Caution Passwords or other sensitive values ...If ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
It also possible to control the format of the output using the --format option; this can take either of the values html or text, with text being the default. This is a Perl script that can be used to estimate the amount of space that would be ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-backup.html
By default, mysqlbinlog reads binary log files and displays their contents in text format. mysqlbinlog writes text output to its standard output, or to the file named as the value of the --result-file=file_name option if that option is given. This ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT, SET PASSWORD, and statements that invoke the PASSWORD() function. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...