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-database.html
If you use DROP DATABASE on a symbolically linked database, both the link and the original database are deleted. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful ...
https://dev.mysql.com/doc/refman/8.0/en/end-markers-in-json-system-variable.html
This variable affects both optimizer traces and the output of EXPLAIN FORMAT=JSON. When reading a very large JSON document, it can be difficult to pair its closing bracket and opening brackets; setting end_markers_in_json=ON repeats the structure's ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-destination-configuration.html
(--console takes precedence over --log-error if both are given, and the following items regarding --log-error do not apply.) If --log-error is not given, or is given without naming a file, the default destination is a file named host_name.err in the ... This section describes which server options configure the default error log destination, which can be the console or a named ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
A recurrent event repeats its action at a regular interval, and the schedule for a recurring event can be assigned a specific start day and time, end day and time, both, or neither. MySQL Events are tasks that run according to a schedule. When you ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
In both cases, this column holds one of the values 'Y' or 'N'. To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
Which action is taken by the server depends on both client and server settings, as discussed later. MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. Passwords can be ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
To fix this disparity between column lengths, use ALTER TABLE to lengthen ActualPC from 10 characters to 15 characters: mysql> ALTER TABLE tt MODIFY ActualPC VARCHAR(15); Now tt.ActualPC and et.EMPLOYID are both VARCHAR(15). The EXPLAIN statement ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
For example, all string functions support both standard SQL syntax and ODBC syntax. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-information-schema.html
What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA? Both Oracle and MySQL provide metadata in tables. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Where can I find the ANSI SQL ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-security.html
Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? Yes, the binaries have SSL enabled for client/server connections that are secured, authenticated, or both. Where can I find documentation that addresses ...