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/commands-out-of-sync.html
If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you ...
https://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
WHERE 'a' = (SELECT column1 FROM t1) MySQL also permits this construct: non_subquery_operand LIKE (subquery) At one time the only legal place for a subquery was on the right side of a comparison, and you might still find some old DBMSs that insist ... The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup operation. However, this cannot be used if you are going to manipulate the database using processes external to the server while you hold ...If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/connection-management.html
This includes a description of the available connection interfaces, how the server uses connection handler threads, details about the administrative connection interface, and management of DNS lookups.
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
WHERE column1 = ANY (SELECT column1 FROM t2) would be TRUE, but in this example, the WHERE clause within the subquery is FALSE (because (5,6) is not equal to (5,7)), so the expression as a whole is FALSE. For example: SELECT column1 FROM t1 AS x ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named function_name. This directory is given by the value of the plugin_dir system variable.
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/cursor-restrictions.html
Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the max_heap_table_size and tmp_table_size system variables. This includes statements such as CHECK TABLE, HANDLER READ, and SHOW BINLOG ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
Example 1: Medical research facilities can hold patient data that comprises a mix of personal and medical data. This may include genetic sequences (long strings), test results stored in JSON format, and other data types. In such cases, data masking ... Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/data-types.html
This chapter provides an overview and more detailed description of the properties of the types in each category, and a summary of the data type storage requirements. (This differs from the standard SQL default of 6, for compatibility with previous ... MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data ...