PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-compatibility.html
Therefore, the following statement causes an error message because the latin2_bin collation is not legal with the latin1 character set: mysql> SELECT _latin1 'x' COLLATE latin2_bin; ERROR 1253 (42000): COLLATION 'latin2_bin' is not valid for ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a nontransactional storage engine, MySQL stops processing the statement at the row ...If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/drop-event.html
If the event does not exist, the error ERROR 1517 (HY000): Unknown event 'event_name' results. DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. The event immediately ceases being active, and is deleted completely ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
If the argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If the argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. MySQL supports the functions listed in this section ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html
If the upgrade is not run, Group Replication fails to start with the error message There was an error when trying to access the server with user: mysql.session@localhost. It is first necessary to ensure that the Group Replication plugin is ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
If the value is not a JSON document, or if it cannot be parsed as one, the function fails with an error. An error results when json_val is not NULL, and is not—or cannot be successfully parsed as—a JSON document. This section documents utility ...
https://dev.mysql.com/doc/refman/5.7/en/large-page-support.html
In the event sysctl returns an error relating to the file name, check the name of the corresponding file in /proc/sys/vm and use that instead. If InnoDB cannot do this, it falls back to use of traditional memory and writes a warning to the error ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is 24710a27dc7a28fb7ee6d825129cd3cf. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-event-reports.html
Each reportable event can be distinguished according to three different criteria: Category: This can be any one of the following values: STARTUP, SHUTDOWN, STATISTICS, CHECKPOINT, NODERESTART, CONNECTION, ERROR, or INFO. Priority: This is ... In ...