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/corrupted-myisam-tables.html
Typical symptoms of a corrupt table are: You get the following error while selecting data from the table: Incorrect key file for table: '...'. You can verify this easily by looking for a recent restarted mysqld message in the error log. Even though ...See Section 15.7.3.2, “CHECK TABLE Statement”, Section 15.7.3.5, “REPAIR TABLE Statement”, and Section 6.6.4, “myisamchk — MyISAM Table-Maintenance ...
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. If you cannot tell from the error log what the problem was, try the following techniques: Verify that the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the column's row is examined. The data length of logged values is limited by the index key limit of ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles Revoking Roles or Role Privileges Dropping Roles User and Role Interchangeability Creating Roles and Granting Privileges to Them ...
https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html
If any SRID argument is not within the range of a 32-bit unsigned integer, an ER_DATA_OUT_OF_RANGE error occurs. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If a latitude value is not in ... The functions listed in this section do not restrict their argument and accept a geometry value of any ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
If both sides have the same coercibility, then: If both sides are Unicode, or both sides are not Unicode, it is an error. For example, the following statement does not return an error: SELECT CONCAT(utf8mb4_column, latin1_column) FROM t1; It returns ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...For example, a ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. The CONNECTION string contains the information required to connect to the remote server containing the table in which the data ...For ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
The group's mode is a group-wide configuration setting, specified by the group_replication_single_primary_mode system variable, which must be the same on all members. These functions manage the process of changing the group's mode and ensure the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-table-insert.html
Each value must match the data type of the column it represents. mysql-js> db.city.insert("ID", "Name", "CountryCode").values( None, "Little Falls", "USA").values(None, "Happy Valley", "USA") When you specify columns using the insert() method, the ... You can use the insert() method with the values() method to insert records into an existing relational ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-table-insert.html
Each value must match the data type of the column it represents. For example, to add a new record to the city table in the world_x database, insert the following record and press Enter twice. mysql-py> db.city.insert("ID", "Name", ... You can use ...