PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...
https://dev.mysql.com/doc/refman/5.7/en/firewall.html
Each MySQL account registered with the firewall has its own statement allowlist, enabling protection to be tailored per account. For a given account, the firewall can operate in recording, protecting, or detecting mode, for training in the accepted ... Note MySQL Enterprise Firewall is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-mysql-firewall-whitelist-table.html
The MYSQL_FIREWALL_WHITELIST table has these columns: USERHOST The account profile name. The MYSQL_FIREWALL_WHITELIST table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-firewall.html
Each MySQL account registered with the firewall has its own statement allowlist, enabling protection to be tailored per account. For a given account, the firewall can operate in recording or protecting mode, for training in the accepted statement ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
Some final instrument names are specific to error handling: statement/com/Error accounts for messages received by the server that are out of band. However, an application that enables or disables statement instruments selectively must take into ...
https://dev.mysql.com/doc/refman/5.7/en/xa.html
A bank keeps account information in an RDBMS and distributes and receives money through automated teller machines (ATMs). It is necessary to ensure that ATM actions are correctly reflected in the accounts, but this cannot be done with the RDBMS ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
You can verify that the UNDO files were created and obtain information about them by querying the Information Schema FILES table. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
Once a data file has been created, its size cannot be changed; however, you can add more data files to the tablespace using additional ALTER TABLESPACE ... In addition, any data file to be dropped must previously have been added to the tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The storage engine creates other files, all having names beginning with the table name. Attempting to create an index on any other column results in ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...