Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
For example, the following statement generates one Query event, two TableRead events, and a TableInsert events: INSERT INTO t3 SELECT t1.* FROM t1 JOIN t2; Each TableXXX event contains <TABLE> and <DB> elements to identify the table to which the ...
https://dev.mysql.com/doc/refman/8.4/en/bit-functions.html
Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
For example, if you insert related pieces of information into several tables, do a single COMMIT after making all the changes. Transferring Data To transfer a large volume of data into an empty InnoDB table created as shown in the previous section, ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
This user then creates the following event: CREATE EVENT e_insert ON SCHEDULE EVERY 7 SECOND DO INSERT INTO myschema.mytable; After this event has been created, root revokes the EVENT privilege for jon@ghidora. However, e_insert continues to ... To ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
For example, it appears for EXPLAIN INSERT INTO t VALUES(10) because that is equivalent to EXPLAIN INSERT INTO t SELECT 10 FROM DUAL. This can also indicate that a WHERE condition of the form NOT IN (subquery) or NOT EXISTS (subquery) has been ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
How do I import an existing MySQL database into an NDB Cluster? A.10.28. How do I import an existing MySQL database into an NDB Cluster? You can import databases into NDB Cluster much as you would with any other version of MySQL. What happens to NDB ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
Firewall Group Profile Tables Firewall Account Profile Tables Firewall Group Profile Tables MySQL Enterprise Firewall maintains group profile information using tables in the firewall database (mysql or custom) for persistent storage and Performance ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. '+apple macintosh' Find rows that contain the word “apple”, but rank rows higher if they also contain “macintosh”. '+apple ... MySQL ...