PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/charset-introducer.html
MySQL determines the character set and collation of a character string literal, hexadecimal literal, or bit-value literal in the following manner: If both _charset_name and COLLATE collation_name are specified, character set charset_name and ... A ...
https://dev.mysql.com/doc/refman/9.7/en/charset-repertoire.html
Consider the following CONCAT() calls: CONCAT(_ucs2 X'0041', _ucs2 X'0042') CONCAT(_ucs2 X'0041', _ucs2 X'00C2') For the first call, the repertoire is ASCII because both arguments are within the ASCII range. IF(column1 < column2, 'smaller', ... The ...
https://dev.mysql.com/doc/refman/9.7/en/checking-gpg-signature-windows.html
This requires files for both the packaged file, and the signature. Table 2.2 MySQL Package and Signature Files for MySQL Server MSI for Microsoft Windows File Type File Name Distribution file mysql-9.7.2-winx64.msi Signature file ... The Section ...
https://dev.mysql.com/doc/refman/9.7/en/commit.html
The READ ONLY restriction prevents the transaction from modifying or locking both transactional and nontransactional tables that are visible to other transactions; the transaction can still modify or lock temporary tables. It is not permitted to ...
https://dev.mysql.com/doc/refman/9.7/en/communication-errors.html
Use of Ethernet protocol with Linux, both half and full duplex. Switch the duplex mode for both your network card and hub/switch to either full duplex or to half duplex and test the results to determine the best setting. If connection problems ...
https://dev.mysql.com/doc/refman/9.7/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/9.7/en/connectors-apis.html
Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment, including ODBC, Java (JDBC), C++, Python, Node.js, PHP, Perl, Ruby, and C. This is the primary method used to connect to an ...
https://dev.mysql.com/doc/refman/9.7/en/converting-tables-to-innodb.html
The InnoDB buffer pool caches both table data and index data, speeding up lookups for queries and keeping query results in memory for reuse. Whether you convert the MyISAM table directly or create a cloned InnoDB table, make sure that you have ...
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
USING HASH prevents the creation of an ordered index; otherwise, creating a unique index or primary key on an NDB table automatically results in the creation of both an ordered index and a hash index, each of which indexes the same set of columns.
https://dev.mysql.com/doc/refman/9.7/en/create-logfile-group.html
You may optionally follow either or both of these with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] ...