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/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 12.21.3, “Expression Handling”, and Section 12.21.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysql_ssl_rsa_setup This program creates the SSL certificate and key files and RSA key-pair files required to support secure connections, if those files are missing. Later sections provide a more detailed description of each one, with the exception ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
For example: SELECT CONCAT(last_name,', ',first_name) AS full_name FROM mytable ORDER BY full_name; The AS keyword is optional when aliasing a select_expr with an identifier. You can use SET max_seeks_for_key=value as an alternative way to force ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
Assuming that class_num is a primary key in the class table, duplicate suppression is possible by using SELECT DISTINCT, but it is inefficient to generate all matching rows first only to eliminate duplicates later. A semijoin is a preparation-time ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
It also includes clauses that specify the trigger action time, the triggering event, and what to do when the trigger activates: The keyword BEFORE indicates the trigger action time. The keyword INSERT indicates the trigger event; that is, the type ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT signal. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account ...
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-encrypted-connections.html
For example, X Plugin can have SSL key, certificate, and certificate authority files that differ from those used for MySQL Server. This section explains how to configure X Plugin to use encrypted connections. To enable configuring support for ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
Example: VERSION="1" JSON Audit Log File Format For JSON-format audit logging (audit_log_format=JSON), the log file contents form a JSON array with each array element representing an audited event as a JSON hash of key-value pairs. The MySQL server ...