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/select.html
In the WHERE expression, you can use any of the functions and operators that MySQL supports, except for aggregate (group) functions. If you are not getting the results that you expect from your query, please read the description of GROUP BY found in ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
A similar statement, SHOW CREATE FUNCTION, displays information about stored functions (see Section 13.7.5.8, “SHOW CREATE FUNCTION Statement”). If you do not have privileges for the routine itself, the value displayed for the Create Procedure ... SHOW CREATE PROCEDURE proc_name This statement is a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
The specification describes a set of SQL geometry types, as well as functions on those types to create and analyze geometry values. MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Object Information System Tables These system tables contain information about stored programs, loadable functions, and server-side plugins: event: The registry for Event Scheduler events installed using CREATE EVENT. During the normal startup ...It ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
The zlib compressBound() function in zlib 1.2.11 returns a slightly higher estimate of the buffer size required to compress a given length of bytes than it did in zlib version 1.2.3. The compressBound() function is called by InnoDB functions that ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
After submission of the keys, the MRR engine functions perform lookups in the index in an optimal way, fetching the rows of the joined table found by these keys, and starts feeding the BKA join algorithm with matching rows. The following setting ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
Within an event body, the CURRENT_USER function returns the account used to check privileges at event execution time, which is the DEFINER user. For example, you could use the GET_LOCK() function, or row or table locking. The ON SCHEDULE clause may ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
(Internal format is like WKB but with an initial 4 bytes to indicate the SRID.) There are functions available to convert between different data formats; see Section 12.16.6, “Geometry Format Conversion Functions”. This differs from the syntax ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
ALTER FUNCTION, CREATE FUNCTION and DROP FUNCTION also cause an implicit commit when used with stored functions, but not with loadable functions. (ALTER FUNCTION can only be used with stored functions.) CREATE TABLE and DROP TABLE statements do not ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
In any query that performs arithmetic using column values, use the CAST() function to convert the values from string to integer, or to some other numeric type. The results are already converted; # no need to repeat conversion functions and WHERE ...