Search Results
https://dev.mysql.com/doc/refman/9.7/en/time.html
For more restrictive treatment of invalid TIME values, enable strict SQL mode to cause errors to occur. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large ...
https://dev.mysql.com/doc/refman/9.7/en/timestamp-initialization.html
Note The following examples use DEFAULT 0, a default that can produce warnings or errors depending on whether strict SQL mode or the NO_ZERO_DATE SQL mode is enabled. TIMESTAMP and DATETIME columns can be automatically initialized and updated to ...
https://dev.mysql.com/doc/refman/9.7/en/too-many-connections.html
If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients. The permitted number of connections is controlled by the max_connections system variable. The ...
https://dev.mysql.com/doc/refman/9.7/en/truncate-table.html
If the tablespace was created with an earlier version and resides in an unknown directory, InnoDB creates the new tablespace in the default location and writes the following warning to the error log: The DATA DIRECTORY location must be in a known ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/uninstall-component.html
If any error occurs, the statement fails and has no effect. A component provides services that are available to the server and other components; see Section 7.5, “MySQL Components”. It requires the DELETE privilege for the mysql.component system ...
https://dev.mysql.com/doc/refman/9.7/en/uninstall-plugin.html
UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. plugin_name must be the name of ...
https://dev.mysql.com/doc/refman/9.7/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...
https://dev.mysql.com/doc/refman/9.7/en/using-system-variables.html
For example, the log_filter_dragnet error log filter component implements a system variable named log_error_filter_rules, the full name of which is dragnet.log_error_filter_rules. The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/doc/refman/9.7/en/values.html
The DEFAULT keyword is not supported by VALUES and causes a syntax error, except when it is used to supply values in an INSERT statement. VALUES is a DML statement which returns a set of one or more rows as a table. In other words, it is a table ...