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/creating-database.html
Creating a database does not select it for use; you must do that explicitly. To make menagerie the current database, use this statement: mysql> USE menagerie Database changed Your database needs to be created only once, but you must select it for ...
https://dev.mysql.com/doc/refman/5.7/en/select-benchmarking.html
For example: mysql> SELECT BENCHMARK(1000000,1+1); +------------------------+ | BENCHMARK(1000000,1+1) | +------------------------+ | 0 | +------------------------+ 1 row in set (0.32 sec) This result was obtained on a Pentium II 400MHz system. To ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-features-to-trace.html
dynamic_range: Only the first call to the range optimizer on this JOIN_TAB::SQL_SELECT is traced. Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason.
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
EXPLAIN returns a row of information for each table used in the SELECT statement. When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows.
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
This includes (but is not limited to) SELECT lists, WHERE and HAVING clauses, and ORDER BY and GROUP BY clauses. row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
mysql> SELECT COALESCE(NULL,1); -> 1 mysql> SELECT COALESCE(NULL,NULL,NULL); -> NULL EXISTS(query) Whether the result of a query contains any rows. mysql> SELECT GREATEST(2,0); -> 2 mysql> SELECT GREATEST(34.0,3.0,5.0,767.0); -> 767.0 mysql> SELECT ... Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); +---------------------------------------------------+ | ...It may be used to time how quickly ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE statements. Hints are permitted in these contexts: At the beginning of query and data change statements: SELECT /*+ ... But this ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
[UNION [ALL | DISTINCT] SELECT ...] UNION combines the result from multiple SELECT statements into a single result set. Selected columns listed in corresponding positions of each SELECT statement should have the same data type. For example, the ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
(SELECT FROM ...), DELETE, and DELETE FROM t1,t2 operations the number of rows affected is returned. select-start(query) select-done(status,rows) insert-start(query) insert-done(status,rows) insert-select-start(query) insert-select-done(status,rows) ... MySQL supports the following static probes, organized into groups of ...