Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
This can be a simple statement such as SELECT or INSERT, or a compound statement written using BEGIN and END. This prohibition includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. MySQL Enterprise Encryption functions are provided by a MySQL component component_enterprise_encryption. For ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
A value of 6 is considered drastic because database pages are left in an obsolete state, which in turn may introduce more corruption into B-trees and other database structures. As a safety measure, InnoDB prevents INSERT, UPDATE, or DELETE ... To ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
If you create a MyISAM table and insert only one or two rows of text into it, every word in the text occurs in at least 50% of the rows. The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. By ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
No read skew on read/write transactions, such as this one: > BEGIN; > SELECT x FROM t1; -- x=1 because x=2 is in the backlog; > INSERT x INTO t2; > COMMIT; This query should not cause a conflict but writes outdated values. In practical terms, the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
An INSERT statement also accesses only one partition per inserted row; this is true even for a table that is partitioned by HASH or KEY although this is not currently shown in the output of EXPLAIN. Pruning can also be applied to short ranges, which ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-float.html
Suppose that you execute the following statements: CREATE TABLE t1(c1 FLOAT(53,0), c2 FLOAT(53,0)); INSERT INTO t1 VALUES('1e+52','-1e+52'); SELECT * FROM t1; On some platforms, the SELECT statement returns inf and -inf. An implication of the ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-hex-string.html
The return value can be placed into an SQL statement using either X'value' or 0xvalue format. Return Values The length of the encoded string that is placed into to, not including the terminating null character. unsigned long mysql_hex_string(char ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #38044940) A java.sql.Time instance created from a negative millisecond value, when inserted into a database via using a PreparedStatement, lost its fractional part of the seconds. (Bug #115845, Bug #36954268) Inserting unsigned big numbers ...