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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/deploy-mysql-nonlinux-docker.html
This section discusses some known issues for the images when used on non-Linux platforms. This is because the way Docker for Windows handles file mounting does not allow a host file from being bind-mounted on the socket file. Warning The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-concepts.html
This section explains the concepts introduced as part of using MySQL as a document store. In terms of MySQL this means: Create a new entry (insertion or addition) Read entries (queries) Update entries Delete entries X Plugin The MySQL Server plugin ...Document A Document is a set of key and value pairs, as represented by a JSON ...
https://dev.mysql.com/doc/refman/5.7/en/drop-server.html
Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
This includes stored programs or views for which the DEFINER attribute names the dropped user. The DROP USER statement removes one or more MySQL accounts and their privileges. It removes privilege rows for the account from all grant tables. To use ...
https://dev.mysql.com/doc/refman/5.7/en/drop-view.html
To avoid this failure scenario, use IF EXISTS syntax in DROP VIEW statements to prevent an error from occurring for views that do not exist. When this clause is given, a NOTE is generated for each nonexistent view. If any views named in the argument ...