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/stored-objects-security.html
Creating a stored object with a nonexistent DEFINER account creates an orphan object, which may have negative consequences; see Orphan Stored Objects. Orphan Stored Objects An orphan stored object is one for which its DEFINER attribute names a ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
The hash index is always built based on an existing B-tree index on the table. The corresponding row in the parent table must exist before the row can be created in the child table. The configuration files used with the MySQL Enterprise Backup ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
(For strings in the ascii or utf8 character sets, no conversion is needed because ascii and utf8 are subsets of utf8mb4.) As an alternative to writing JSON values using literal strings, functions exist for composing JSON values from component ...The ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
Statements use IF EXISTS because, depending on the previously installed firewall version, some objects might not exist. MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 6.4.6.1, ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
If you plan to do that, make sure that an account exists that can accept a connection. For existing tables that do not explicitly define a ROW_FORMAT option or that use ROW_FORMAT=DEFAULT, any operation that rebuilds a table also silently changes ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
For example, you can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. Running ALTER TABLE tbl_name ENGINE=INNODB on an existing InnoDB table performs a “null” ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
Either create the account if it does not exist (see Create a mysql User and Group), or substitute the name of a different existing login account that you plan to use for running the server. (For upgrades to an existing installation, perform the ...
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/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
You can verify that all existing data nodes were restarted using the updated configuration by checking the ndbinfo.nodes table in the mysql client. However, in NDBCLUSTER tables that existed prior to the addition of the new nodes, neither existing ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...