Search Results
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
Datetime literals that include time zone offsets are accepted as parameter values by prepared statements. Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in ...
https://dev.mysql.com/doc/refman/8.4/en/differences-from-ansi.html
You must explicitly issue a REVOKE statement to revoke privileges for a table. We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connections.html
For information on how to require users to use encrypted connections, see the discussion of the REQUIRE clause of the CREATE USER statement in Section 15.7.1.3, “CREATE USER Statement”. With an unencrypted connection between the MySQL client ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-priority-based-filtering.html
log_error_verbosity Value Permitted Message Priorities 1 ERROR 2 ERROR, WARNING 3 ERROR, WARNING, INFORMATION If log_error_verbosity is 2 or greater, the server logs messages about statements that are unsafe for statement-based logging. The ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
A rule set consists of zero or more rules, where each rule is an IF statement terminated by a period (.) character. Each rule is an IF statement terminated by a period (.) character. The log_filter_dragnet log filter component enables log filtering ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log. These indicate issues of interest to database administrators or that require DBA action.
https://dev.mysql.com/doc/refman/8.4/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
Using the statement SET [GLOBAL|SESSION] sql_mode='modes', you can change the settings from within a connection, either locally to the connection, or to take effect globally. You can retrieve the current mode by issuing a SELECT @@sql_mode statement. What is the default server SQL mode when MySQL 8.4 is installed? ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...