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/identifier-length.html
If the table name is close to the length limit for constraint names, the additional characters required for the constraint name may cause that name to exceed the limit, resulting in an error. This applies to identifiers in table definitions and to ... The following table describes the maximum length for each type of ...See Section ...
https://dev.mysql.com/doc/refman/8.0/en/invoking-programs.html
For example, the mysql program interprets the first nonoption argument as a database name, so the command mysql --user=root test indicates that you want to use the test database. Other connection options are --port (or -P) to specify a TCP/IP port ... To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or other arguments needed to instruct the program what you want it to ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-server.html
This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations. You can specify these options on the command line, ...
https://dev.mysql.com/doc/refman/8.0/en/perl-support-problems.html
On Linux, you can add the path name of the directory where libmysqlclient.so is located to the /etc/ld.so.conf file. If you get the following errors from DBD::mysql, you are probably using gcc (or using an old binary compiled with gcc): ... If Perl ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Enable profiling by setting profiling to 1 or ON: mysql> SET profiling = 1; SHOW PROFILES displays a list of the most recent ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. Spatial computations may detect some cases of invalid geometries and raise an error, but they may also return an undefined ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-reserved-words.html
Replication can fail in such cases with Error 1064 You have an error in your SQL syntax..., even if a database or table named using the reserved word or a table having a column named using the reserved word is excluded from replication. This is due ...In any SQL statements using these database object names, write the names as quoted identifiers using backtick characters ... You can encounter problems when you attempt to replicate from an older source to a newer ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching rows. If no matching record is found, it returns the error ER_KEY_NOT_FOUND and stops the replication ...The ...
https://dev.mysql.com/doc/refman/8.0/en/row-subqueries.html
An error occurs if the subquery produces multiple rows because a row subquery can return at most one row. The row constructor and the row returned by the subquery must contain the same number of values. Thus, the following query fails with a syntax ...If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query returns those t1 ...