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/alter-user.html
By default, an error occurs if you try to modify a user that does not exist. If the IF EXISTS clause is given, the statement produces a warning for each named user that does not exist, rather than an error. Operations performed by a restricted ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), g VARCHAR(6000)) ENGINE=InnoDB CHARACTER SET latin1; ERROR 1118 (42000): Row size too large. You have to change some ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-enum.html
An error occurs for values that do not satisfy these conditions: An ENUM value must be one of those listed in the column definition, or the internal numeric equivalent thereof. The value cannot be the error value (that is, 0 or the empty string).
https://dev.mysql.com/doc/refman/8.0/en/constraints.html
We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs. The basic philosophy is that MySQL Server tries to produce an error for anything that ... MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax error. If errors occur while copying data to the table, the table is automatically dropped and not created. If ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
The error message includes the parse error only if the statement is provided as a literal string. If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. This avoids potential problems with trailing space ...
https://dev.mysql.com/doc/refman/8.0/en/file-permissions.html
For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/file_name' (Errcode: 13) The default UMASK and UMASK_DIR values are 0640 and 0750, respectively. If this is unsuitable, create ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
If the options argument is invalid, an error occurs to indicate why. If an SRID argument refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. For geographic SRS geometry arguments, if any argument has a longitude ... These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
Beyond the cases described here, the behavior of FOUND_ROWS() is undefined (for example, its value following a SELECT statement that fails with an error). ICU_VERSION() The version of the International Components for Unicode (ICU) library used to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
If the row does not fit, the following error message is issued: ERROR HY000: Too big row. If you create a table when innodb_strict_mode is OFF, and a subsequent INSERT or UPDATE statement attempts to create an index entry that does not fit in the ...