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/arithmetic-functions.html
+ Addition: mysql> SELECT 3+5; -> 8 - Subtraction: mysql> SELECT 3-5; -> -2 - Unary minus. mysql> SELECT - 2; -> -2 Note If this operator is used with a BIGINT, the return value is also a BIGINT. * Multiplication: mysql> SELECT 3*5; -> 15 mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
The EXPLAIN SELECT example later in this section demonstrates the use of \G. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
You need only the SELECT privilege for any columns that are only read, such as those named in the WHERE clause. Subqueries You cannot delete from a table and select from the same table in a subquery. Partitioned Table Support DELETE supports ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers do not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... EXPLAIN SELECT to obtain a description of how tables are processed by ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
Each mysql system database table is accessible only by accounts that have the SELECT privilege for it. Firewall Account Profile Functions Firewall Miscellaneous Functions Firewall Account Profile Functions These functions perform management ...When ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when selecting from one table) or combination of rows (when selecting from a multiple-table join). This UPDATE statement uses a ...A function ...
https://dev.mysql.com/doc/refman/5.7/en/gis-linestring-property-functions.html
mysql> SET @ls = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))); +----------------------------------------------+ | ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))) | ...You can extract particular points of a ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
Converted to a number, it produces 0: mysql> SELECT CHARSET(X''), LENGTH(X''); +--------------+-------------+ | CHARSET(X'') | LENGTH(X'') | +--------------+-------------+ | binary | 0 | +--------------+-------------+ mysql> SELECT X''+0; +-------+ ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
SELECT FILE_ID, FILE_NAME, FILE_TYPE, TABLESPACE_NAME, FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE, DATA_FREE, STATUS FROM INFORMATION_SCHEMA.FILES WHERE ENGINE='InnoDB'\G NDB Notes The FILES table provides ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
mysql> SET GLOBAL innodb_monitor_reset = dml_inserts; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME="dml_inserts"\G *************************** 1. mysql> SET GLOBAL innodb_monitor_disable = ...