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/converting-tables-to-innodb.html
For better control over the insertion process, you can insert big tables in pieces: INSERT INTO newtable SELECT * FROM oldtable WHERE yourkey > something AND yourkey <= somethingelse; After all records are inserted, you can rename the tables. If ...
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
In this case, remove or rename the data directory and try again. After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For some MySQL installation methods, data directory initialization ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
Once this limit is exceeded, you must rename or remove the file before it is possible to execute any additional DDL statements. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
If a new version of MySQL implements a built-in function with the same name as an existing stored function, you have two choices: Rename the stored function to use a nonconflicting name, or change calls to the function so that they use a schema ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat count. The intended use is from within the mysql client, which reports query execution ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
This function was renamed to JSON_ARRAY_APPEND() in MySQL 5.7.9; the alias JSON_APPEND() is now deprecated in MySQL 5.7, and is removed in MySQL 8.0. The functions in this section modify JSON values and return the result. JSON_APPEND(json_doc, ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
The decrypted file should display on the console: $> openssl rsa -in key.pem.new -passin file:password.txt Remove the original key.pem file and rename key.pem.new to key.pem. Note The keyring_okv plugin is an extension included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
SELECT ..., then drop the old table and rename the new one, but this could be very time-consuming when dealing with a large amounts of data. Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the ...