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/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Today, MySQL Server and many other modern database systems offer a wide range of outer join types. MySQL Server supports multiple-table DELETE statements ...Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these techniques rather than to use ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
The information in the binary log is stored in different logging formats according to the database changes being recorded. This section describes replication between MySQL servers based on the binary log file position method, where the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-find-table.html
Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. You can check which tables are in the default database with SHOW TABLES.
https://dev.mysql.com/doc/refman/5.7/en/binary-log-formats.html
The logging format can also be set or limited by the storage engine being used. The server uses several logging formats to record information in the binary log. The exact format employed depends on the version of MySQL being used. There are three ...In row-based logging, the source writes events to the binary log that indicate how individual table rows are ...
https://dev.mysql.com/doc/refman/5.7/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); .
https://dev.mysql.com/doc/refman/5.7/en/data-masking-elements.html
A set of loadable functions provides an SQL-level API for performing masking and de-identification operations. MySQL Enterprise Data Masking and De-Identification is based on a plugin library that implements these elements: A server-side plugin ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption.html
MySQL Enterprise Edition includes a set of encryption functions based on the OpenSSL library that expose OpenSSL capabilities at the SQL level. Note MySQL Enterprise Encryption is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/foreign-key-optimization.html
That way, each small table can have a primary key for fast lookups of its data, and you can query just the set of columns that you need using a join operation. Depending on how the data is distributed, the queries might perform less I/O and take up ... If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the numeric ID column from the main ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-multipoint.html
On a city map, a MultiPoint could represent the outlets for a ticket office. A MultiPoint is a geometry collection composed of Point elements. MultiPoint Examples On a world map, a MultiPoint could represent a chain of small islands. A MultiPoint ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-shutdown-restart.html
To restart the cluster on Unix platforms, run these commands: On the management host (198.51.100.10 in our example setup): $> ndb_mgmd -f /var/lib/mysql-cluster/config.ini On each of the data node hosts (198.51.100.30 and 198.51.100.40): $> ndbd Use ...On Windows platforms, assuming that you have installed the SQL node as a Windows service, you can use SC STOP service_name or NET STOP ... To shut down the cluster, enter the following command in a shell on the ...