PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
Phone numbers can be given in very different formats: +7-12345-67 +7-12-345-67 +7 12 345 67 +7 (12) 345 67 +71234567 The problem raised by dealing with these kinds of values is that the varying permissible formats make searching for a specific phone ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
This limits scalability when load increases, particularly for statement mixes that include writes. To enforce different size limits for MEMORY tables, change the value of this variable. You can set the size for individual tables as described later ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. It can also be used for queries that specify just a last_name value because that column is a leftmost prefix of the index (as ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
Use this for tables that are heavily used for searches but that are not updated. This feature enables you to assign different table indexes to different key caches. Any attempt to do this is ignored: mysql> SET GLOBAL key_buffer_size = 0; mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
This can also be changed by changing the source and recompiling. This is done by automatically combining adjacent deleted blocks and by extending blocks if the next block is deleted. myisamchk --fast checks only those tables that don't have this ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
This enables you to specify all tables in a directory by using the pattern *.MYI. You should then ensure that no one is using the tables while you are running myisamchk However, the easiest way to avoid this problem is to use CHECK TABLE instead of ... The myisamchk utility gets information about your database tables or checks, repairs, or optimizes ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
The easiest way to accomplish this is to do a search-and-replace on the file that contains the definitions and replace all instances of TYPE=engine_name or ENGINE=engine_name with ENGINE=NDBCLUSTER. Note The information in this section applies to ...Working with database tables and data in NDB Cluster is not much different from doing so in standard ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3). In this context, VARCHAR and CHAR are considered the same if they are declared as the same ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-collections-add.html
In this example we are using the world_x schema imported previously, and the countryinfo collection. As this is multi-line content, press Enter twice to insert the document. A MySQL server at an earlier 8.0 release or at 5.7 does not set an _id ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-in-tables.html
Examples in this section use the city table in the world_x schema. mysql-js> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with a search condition that evaluates ... In MySQL, a table may contain traditional relational data, JSON values, or ...