PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/drop-trigger.html
Use IF EXISTS to prevent an error from occurring for a trigger that does not exist. DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP ...
https://dev.mysql.com/doc/refman/8.0/en/end-markers-in-json-system-variable.html
Note If end_markers_in_json is enabled, the repetition of the key means the result is not a valid JSON document, and causes JSON parsers to throw an error. When reading a very large JSON document, it can be difficult to pair its closing bracket and ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
(Do you see the error in the statement? The string 'Smith is missing the second single quotation mark.) At this point, what do you do? The simplest thing is to cancel the query. Make sure that you are connected to the server, as discussed in the ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. key_str is a valid PEM encoded RSA public or private key. pub_key_str and ... In releases before MySQL 8.0.30, MySQL Enterprise Encryption's functions are based on the openssl_udf shared ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. In releases from MySQL 8.0.30, MySQL Enterprise Encryption's functions ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
Syntactically invalid event creation and modification statements fail with an appropriate error message. MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'mysql_firewall_mode'; +---------------------+-------+ | Variable_name | Value | +---------------------+-------+ | mysql_firewall_mode | ON | ...
https://dev.mysql.com/doc/refman/8.0/en/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...
https://dev.mysql.com/doc/refman/8.0/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
The loose prefix allows you restart MySQL without encountering an error due to an unrecognized variable. The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a ...