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/alter-function.html
ALTER FUNCTION func_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...More ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
There are exceptions when you cannot switch the replication format at runtime: The replication format cannot be changed from within a stored function or a trigger. Where possible, rows stored in the binary log are grouped into events with a size not ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error. In some cases, it may be desirable to store binary data such as media files in BLOB or TEXT columns. A BLOB is a binary large object that can hold a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
For the binary character set, the concepts of lettercase and accent equivalence do not apply: For single-byte characters stored as binary strings, character and byte boundaries are the same, so lettercase and accent differences are significant in ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
Numbers with a value of zero are stored using one bit. If values in an integer column have a small range, the column is stored using the smallest possible type. For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) ... Compressed storage format is a read-only format that is generated with the myisampack ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In the following commands, DUMPDIR represents the full path name of the directory you use to store the output from mysqldump. In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. When you store data into the table, the storage engine saves it into the data file in comma-separated values format. The CSV storage engine is always compiled ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
In previous MySQL releases, dictionary data was partially stored in metadata files. Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables. Issues with file-based metadata storage included expensive ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. The ndbinfo directory corresponds to the ndbinfo database that stores information specific to NDB Cluster (present only for installations built to ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
Substitution of data by data from dictionaries stored in the database. This may include genetic sequences (long strings), test results stored in JSON format, and other data types. Note MySQL Enterprise Data Masking and De-Identification is an ...