PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/row-constructor-optimization.html
For example, these two statements are semantically equivalent: SELECT * FROM t1 WHERE (column1,column2) = (1,1); SELECT * FROM t1 WHERE column1 = 1 AND column2 = 1; In addition, the optimizer handles both expressions the same way. However, the row ...The optimizer is less likely to use available indexes if the row constructor columns do not cover the prefix of an ...
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. The ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
To make FILE-privilege operations a bit safer, files generated with SELECT ... This could be abused, for example, by using LOAD DATA to load /etc/passwd into a table, which then can be displayed with SELECT. If the plugin directory is writable by ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
To specify the log destination, use the log_output system variable (as described in Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). However, further logging of queries to the file does not occur unless the ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
mysql> SELECT ST_GeoHash(180,0,10), ST_GeoHash(-180,-90,15); +----------------------+-------------------------+ | ST_GeoHash(180,0,10) | ST_GeoHash(-180,-90,15) | +----------------------+-------------------------+ | xbpbpbpbpb | 000000000000000 | ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-mbr.html
mysql> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'); mysql> SET @g2 = ST_GeomFromText('Point(1 1)'); mysql> SELECT MBRContains(@g1,@g2), MBRWithin(@g2,@g1); +----------------------+--------------------+ | MBRContains(@g1,@g2) | ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
To see the current set of optimizer flags, select the variable value: mysql> SELECT @@optimizer_switch\G *************************** 1. Suppose that all Index Merge optimizations are enabled: mysql> SELECT @@optimizer_switch\G ...Its value is a set ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. For example, if you try to select rows ... MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'audit%'; +-------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-------------+---------------+ | audit_log | ACTIVE | ... This ...