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/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-stop.html
On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from the PID column of the clone_status table. These methods of obtaining the PID information can be used on the donor or recipient ...
https://dev.mysql.com/doc/refman/8.0/en/collation-diagnostics.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
LIKE to create an empty table based on the definition of a table that resides in the mysql tablespace, InnoDB system tablespace (innodb_system), or a general tablespace. You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
MySQL supports many different storage engines (table types) and row formats. MySQL has many specialized types that save disk space and memory. If it is very likely that a long string column has a unique prefix on the first number of characters, it ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/8.0/en/drop-database.html
The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation. This includes all files with the extensions shown in the following list: .BAK .DAT .HSH .MRG .MYD ... DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the ...
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
See Section 27.2.2, “Stored Routines and MySQL Privileges”.) In addition, if the definer of the routine has the SYSTEM_USER privilege, the user dropping it must also have this privilege. DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These ...
https://dev.mysql.com/doc/refman/8.0/en/drop-spatial-reference-system.html
For example: mysql> DROP SPATIAL REFERENCE SYSTEM 4326; ERROR 3716 (SR005): Can't modify SRID 4326. Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] (reserved by ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system schema. As of MySQL 8.0.22, DROP USER fails with an error ...It removes privilege rows for the account from all grant ...
https://dev.mysql.com/doc/refman/8.0/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.