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/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an expression; it need not be a constant. If the DEFAULT clause ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-examples-of-use-case-scenarios.html
The following examples are typical use cases for Group Replication. Elastic Replication - Environments that require a very fluid replication infrastructure, where the number of servers has to grow or shrink dynamically and with as few side-effects ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered firewall account profiles. It is used in conjunction with the mysql.firewall_users system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-dictionary.html
The InnoDB data dictionary is comprised of internal system tables that contain metadata used to keep track of objects such as tables, indexes, and table columns. For historical reasons, data dictionary metadata overlaps to some degree with ...
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/primary-key-optimization.html
The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance benefits from the NOT NULL optimization, because it cannot include any NULL values. With the InnoDB storage engine, the ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-in-select.html
Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. Two query cache-related options may be specified in SELECT statements: SQL_CACHE The query result is cached if it is cacheable and the value of the query_cache_type ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-floatvalues.html
With statement-based replication, values are converted from decimal to binary. Because conversions between decimal and binary representations of them may be approximate, comparisons involving floating-point values are inexact. This is true for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-flush.html
Some forms of the FLUSH statement are not logged because they could cause problems if replicated to a replica: FLUSH LOGS and FLUSH TABLES WITH READ LOCK. The FLUSH TABLES, ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements are written to ...