Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
The reason that a long running transaction can cause the History list length to increase is that under a consistent read transaction isolation level such as REPEATABLE READ, a transaction must return the same result as when the read view for that ...
https://dev.mysql.com/doc/refman/8.4/en/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. Reading master dump table data This state occurs after Opening master dump table. Rebuilding the index on master dump table This state occurs after Reading master ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
MySQL recognizes the escape sequences shown in Table 11.1, “Special Character Escape Sequences”. For the escape sequences that represent each of these characters, see Table 11.1, “Special Character Escape Sequences”. A string is a sequence ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
In the preceding discussion, the data set stored in tstable happens to consist of distinct UTC values. If the index is not UNIQUE, it is possible for the table (and the index) to store multiple instances of a given UTC value. Temporal values are ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-api-components.html
For new MySQL installations, this table is created during the installation process. SQL statements: INSTALL PLUGIN registers a plugin in the mysql.plugin table and loads the plugin code. UNINSTALL PLUGIN unregisters a plugin from the mysql.plugin ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. Without this option, mysqldump treats the first name as a database name and those following as table names. With --all-databases or --databases, mysqldump writes CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
The Contents subtab defines the schemas and tables to back up, and whether the job is a full or partial backup: Full backup: All schemas and tables are backed up (see the figure that follows). Figure 6.28 Workbench: MySQL Enterprise Backup ... This ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-serverprep.html
For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, file_size MEDIUMINT UNSIGNED NOT NULL, file MEDIUMBLOB NOT NULL); After creating ... The first step is using MySQL with BLOB data is to configure the ...