PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-drop-if-exists.html
IF EXISTS statements for stored programs (stored procedures and functions, triggers, and events) are also replicated, even if the stored program to be dropped does not exist on the source. The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. For stored program objects, the Performance Schema takes the ENABLED and TIMED columns directly from the setup_objects row. The ...
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 ...