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/datetime.html
This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter-installation.html
If the plugin fails to initialize, check the server error log for diagnostic messages. This section describes how to install or uninstall the ddl_rewriter plugin. For general information about installing plugins, see Section 7.6.1, “Installing ...
https://dev.mysql.com/doc/refman/8.0/en/deallocate-prepare.html
Attempting to execute a prepared statement after deallocating it results in an error. {DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared ...
https://dev.mysql.com/doc/refman/8.0/en/delete-optimization.html
Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Explicitly specified ASC and DESC designators for HASH, FULLTEXT, and SPATIAL indexes results in an error. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order.
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. See the discussion here ...
https://dev.mysql.com/doc/refman/8.0/en/drop-database.html
IF EXISTS is used to prevent an error from occurring if the database does not exist. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with this statement! To use ...
https://dev.mysql.com/doc/refman/8.0/en/drop-logfile-group.html
The log file group must already exist or an error results. DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. (For information on creating log file groups, see Section 15.1.16, ...
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
It prevents an error from occurring if the procedure or function does not exist. DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or function). (DROP FUNCTION is also used to ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
If the tablespace is not empty, DROP TABLESPACE returns an error. DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. The UNDO keyword, introduced in ...