PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. Using prepared ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
The binary log contains information about SQL statements that modify database contents. These events bring databases up to date from the point of the backup. Instead, each reference to a local variable is replaced by this construct for logging ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
For example, for the MyISAM tables in the mysql database, there must be no administrative changes to MySQL accounts during the backup. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is metadata. Thus column names, database names, user names, version names, and most of the string results from SHOW ...Representation of metadata must satisfy these requirements: All metadata must be in the same character ...
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
We continue to support transactional and nontransactional databases to satisfy both mission-critical 24/7 usage and heavy Web or logging usage. MySQL Server was originally designed to work with medium-sized databases (10-100 million rows, or about ... This section describes how MySQL relates to the ANSI/ISO SQL ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Converting an Existing Table To convert a non-InnoDB table to use InnoDB use ALTER TABLE: ALTER TABLE table_name ENGINE=InnoDB; Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. In the case of a runaway ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
Does MySQL permit CJK characters to be used in database and table names? A.11.18. Make sure that the database is actually using the desired character set. Does MySQL permit CJK characters to be used in database and table names? Yes. This set of ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
Data definition language (DDL) statements that define or modify database objects. SELECT.) Statements that implicitly use or modify tables in the mysql database. The statements listed in this section (and any synonyms for them) implicitly end any ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. Before querying it, set the value of the ... The ...