PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-ssl-rsa-setup.html
Another way to generate SSL and RSA files, for MySQL distributions compiled using OpenSSL, is to have the server generate them automatically. Important mysql_ssl_rsa_setup helps lower the barrier to using SSL by making it easier to generate the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
(See Section 16.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. SYSDATE() is automatically replicated using ...
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/mysql-cluster-replication-schema.html
0 in the epoch column of this table indicates a transaction originating from a storage engine other than NDB. The number of epochs per binary log file normally depends on the amount of binary log generated per epoch and the size of the binary log ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. (This applies to statements terminated by ; or \G.) --batch, -B Command-Line Format --batch Print results using tab as the column separator, with each row on a ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
column->path In MySQL 5.7.9 and later, the -> operator serves as an alias for the JSON_EXTRACT() function when used with two arguments, a column identifier on the left and a JSON path (a string literal) on the right that is evaluated against the ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
SELECT, the destination table does not preserve information about whether columns in the selected-from table are generated columns. The SELECT part of the statement cannot assign values to generated columns in the destination table. You can create ...The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
KEY takes only a list of zero or more column names. Any columns used as the partitioning key must comprise part or all of the table's primary key, if the table has one. Where no column name is specified as the partitioning key, the table's primary ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...