PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
If both the default settings are used, the replica waits 60 seconds between reconnection attempts (MASTER_CONNECT_RETRY=60), and keeps attempting to reconnect at this rate for 60 days (MASTER_RETRY_COUNT=86400). ] CHANGE MASTER TO changes the ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
COUNT(expr) Returns a count of the number of non-NULL values of expr in the rows retrieved by a SELECT statement. mysql> SELECT student.student_name,COUNT(*) FROM student,course WHERE student.student_id=course.student_id GROUP BY student_name; ...
https://dev.mysql.com/doc/refman/5.7/en/gis-wkt-functions.html
If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL. If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, ... These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
ALGORITHM=INPLACE is not permitted under certain conditions if columns have to be converted to NOT NULL. For a PRIMARY KEY index, MySQL also checks that none of the PRIMARY KEY columns contains a NULL. When you add a primary key using the ... Online ...
https://dev.mysql.com/doc/refman/5.7/en/all-subqueries.html
The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The expression is unknown (that is, NULL) if table t2 contains (0,NULL,1). The expression is TRUE if table t2 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
For a join based on the <=> comparison operator, NULL is not treated differently from any other value: NULL <=> NULL, just as N <=> N for any other N. However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
SUBPARTITION_NAME If the PARTITIONS table row represents a subpartition, the name of subpartition; otherwise NULL. For tables using other storage engines and which are not partitioned, this column is NULL. For partitions whose PARTITION_METHOD is ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...