PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
If this step causes any warnings in the log, adjust your application so that it only uses GTID-compatible features and does not generate any warnings. You must ensure that no warnings are being generated in the error logs before going to the next ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
If an application generates a query such as SELECT * FROM table WHERE ID=234 when a user enters the value 234, the user can enter the value 234 OR 1=1 to cause the application to generate the query SELECT * FROM table WHERE ID=234 OR 1=1. Your ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
MySQL servers compiled using OpenSSL can generate missing certificate and key files automatically at startup. (The files need not have been generated automatically; what matters is that they have those names and are valid.) If the server does not ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The ENUM type has these advantages: Compact data storage in situations where a column ...See Section 11.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
group_replication_auto_increment_increment: Determines interval between successive column values for transactions executing on this server. innodb_log_checksum_algorithm: Specifies how to generate and verify checksum stored in each redo log disk ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
--complete-insert Command-Line Format --complete-insert Write complete INSERT statements that include column names. The output generated by using --events contains CREATE EVENT statements to create the events. --hex-blob Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
Each row in the index node contains the values of the (user-specified or system-generated) primary key and all the other columns of the table. The pointer is in fact the value of the primary key of the table, which is used to access the clustered ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. In any query that performs arithmetic using column values, use the CAST() function to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
With the exception of the blocks and config_params tables, what we refer to as ndbinfo “tables” are actually views generated from internal NDB tables not normally visible to the MySQL Server. All ndbinfo tables are read-only, and are generated ... ndbinfo is a database containing information specific to NDB ...