PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/conditions-and-parameters.html
If the exception is an error, the values of OUT and INOUT parameters are not propagated back to the caller. If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller.
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
If a parameter is specified more than once, an error occurs. In URI-like strings, they must be encoded, using either percent encoding or by surrounding the path with parentheses. Parentheses eliminate the need to percent encode characters such as ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
If the server refuses a connection because the max_connections limit is reached, it increments the Connection_errors_max_connections status variable. This section describes aspects of how the MySQL server manages client connections. Network ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
If a client attempts to connect using these protocols, for TCP connections, the connection fails, and an error is returned to the client. This section describes options supported by most MySQL client programs that control how client programs ...
https://dev.mysql.com/doc/refman/8.0/en/create-database.html
An error occurs if the database exists and you did not specify IF NOT EXISTS. For information about character set and collation names, see Chapter 12, Character Sets, Collations, Unicode. If a database name contains special characters, the name for ... CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns an error if ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE is specified. You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the ...
https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html
IF NOT EXISTS prevents an error from occurring if a trigger having the same name, on the same table, exists in the same schema. CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
For any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error if not. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
For temporal types that include a date part (DATE, DATETIME, and TIMESTAMP), use of these values may produce warning or errors. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. Each ...