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/perror.html
For most system errors, MySQL displays, in addition to an internal text message, the system error code in one of the following styles: message ... (Errcode: #) You can find out what the error code means by examining the documentation for your ...
https://dev.mysql.com/doc/refman/5.7/en/procedure-analyse.html
You may need to try different settings for the arguments so that PROCEDURE ANALYSE() does not suggest the ENUM data type when it is not appropriate. ANALYSE() examines the result from a query and returns an analysis of the results that suggests ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-server.html
The information in this section is appropriate for DBAs who want to ensure performance and scalability across the servers they manage; for developers constructing installation scripts that include setting up the database; and people running MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
Matching performed by the LIKE clause is dependent on the setting of the lower_case_table_names system variable. SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database.
https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
As a source of data for experimentation: To make a copy of a database that you can use without changing the original data. This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation-layout.html
include Include (header) files lib Libraries share Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation . Table 2.4 Default MySQL Installation Layout for Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
For certain data types, you can index a prefix of the column (see Section 8.3.4, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first ... MySQL can create composite indexes (that is, indexes on multiple ...
https://dev.mysql.com/doc/refman/5.7/en/null-values.html
Treatment of \N as a synonym for NULL in SQL statements is deprecated as of MySQL 5.7.18 and is removed in MySQL 8.0; use NULL instead. Be aware that the NULL value is different from values such as 0 for numeric types or the empty string for string ... The NULL value means “no data.” NULL can be written in any ...