Search Results
https://dev.mysql.com/doc/refman/8.4/en/blob.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. This means that, if the index requires unique values, duplicate-key errors occur for values ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-disconnecting.html
For help with other problems often encountered when trying to log in, see Section B.3.2, “Common Errors When Using MySQL Programs”. To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
If the server does not recognize the cost name when it reads this table, it writes a warning to the error log. If the server finds that the cost value is invalid (nonpositive) when it reads this table, it writes a warning to the error log. If the ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/8.4/en/create-role.html
(These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. By default, an error ... CREATE ROLE [IF NOT EXISTS] role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
Installation using RPM packages generates an initial random password, which is written to the server error log. For data directory initialization performed manually using mysqld --initialize, mysqld generates an initial random password, marks it ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
The IGNORE modifier causes MySQL to ignore ignorable errors during the process of deleting rows. (Errors encountered during the parsing stage are processed in the usual manner.) Errors that are ignored due to the use of IGNORE are returned as ...
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
DROP ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. By default, an error occurs if you try to drop a role that does not exist. If the IF EXISTS clause is given, the statement produces a warning for each ...DROP ROLE removes one or more roles (named collections of ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
Use of multiple operators on a single search word returns a syntax error to standard out. Specifying a trailing plus or minus sign causes InnoDB to report a syntax error. MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...