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/create-table-generated-columns.html
For INSERT, REPLACE, and UPDATE, if a generated column is inserted into, replaced, or updated explicitly, the only permitted value is DEFAULT. Values of a generated column are computed from an expression included in the column definition. Generated ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
mysql> SELECT TO_DAYS(950501); -> 728779 mysql> SELECT TO_DAYS('2007-10-07'); -> 733321 TO_DAYS() is not intended for use with values that precede the advent of the Gregorian calendar (1582), because it does not take into account the days that were ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
The following means are available to influence whether the optimizer attempts to merge derived tables and view references into the outer query block: The derived_merge flag of the optimizer_switch system variable can be used, assuming that no other ...The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir Logical Downgrade Logical downgrade involves using mysqldump to dump all tables from the new MySQL version, and then loading the dump file into ... This section describes how to downgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-format.html
However, if a row becomes larger, it is split into as many pieces as are required, resulting in row fragmentation. More difficult than static-format tables to reconstruct after a crash, because rows may be fragmented into many pieces and links ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't ยป have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-security.html
Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? Yes, the binaries have SSL enabled for client/server ...Where can I find documentation that addresses security issues for MySQL? ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
It implements the required ADO.NET interfaces and integrates into ADO.NET aware tools. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL.
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. MATCH (col1,col2,...) AGAINST (expr ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
Loadable functions, as the name implies, must be loaded into the server before they can be used. CREATE FUNCTION has these effects: It loads the function into the server to make it available immediately. MySQL supports automatic function loading ...