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/logical-operators.html
Table 12.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations. A self-referential ON DELETE SET NULL, on the other hand, is possible, as is a self-referential ON DELETE ...For example, if you define a RESTRICT type constraint, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
row *************************** id: 1 select_type: SIMPLE table: VIEWS type: ALL possible_keys: NULL key: TABLE_SCHEMA,TABLE_NAME key_len: NULL ref: NULL rows: NULL Extra: Using where; Open_frm_only; Scanned 0 databases Use of constant database and ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the replica. Before skipping a transaction, ensure that the replication I/O thread is stopped as well ...
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/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/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/outer-join-simplification.html
Instead, MySQL converts the query to a query with no outer join operation if the WHERE condition is null-rejected. (That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it ...
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 ...