Search Results
https://dev.mysql.com/doc/refman/8.4/en/delete.html
Unlike DELETE, TRUNCATE TABLE cannot be used within a transaction or if you have a lock on the table. They remain underfilled when new inserts occur, because new rows do not have index values in the deleted range. For example, to delete rows that ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
Note Exploits for the MD5 and SHA-1 algorithms have become known. This function requires MySQL to have been compiled with a compression library such as zlib. The second argument indicates the desired bit length of the result, which must have a value ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
Both operators have the same precedence and evaluate left to right. Symbolic names can be specified as quoted strings for comparison with string fields, but in such cases the names are strings that have no special meaning and log_filter_dragnet does ... The log_filter_dragnet log filter component enables log filtering based on user-defined ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
Since the user does not have the INSERT privilege for the table in question, the event has no effect. In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM ... To ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
MySQL 8.4 supports a FOR SCHEMA clause, which causes EXPLAIN to behave as if the statement to be analyzed had been executed in the named database; FOR DATABASE is supported as a synonym. If the user does not have the necessary privileges to run the ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/refman/8.4/en/expressions.html
Intervals have this syntax: INTERVAL expr unit expr represents a quantity. For example, if you specify a unit of DAY_SECOND, the value of expr is expected to have days, hours, minutes, and seconds parts. This section lists the grammar rules that ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? A.6.4. Can you insert into views that are based on joins? A.6.1. Where can I find documentation covering MySQL Views? See Section 27.5, “Using Views”. You may also find the ...
https://dev.mysql.com/doc/refman/8.4/en/geometry-well-formedness-validity.html
For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
This member needs to have the same replication user configured in Section 20.2.1.3, “User Credentials For Distributed Recovery”. If you did not have binary logging enabled when you configured the user credentials on s1, and a remote cloning ...