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/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
To force them to be created (or updated if they already exist), invoke ndb_index_stat with the --update option, or execute ANALYZE TABLE on the table in the mysql client. --sys-create Command-Line Format --sys-create Create all statistics tables and ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. Care should be taken when creating a FEDERATED table since the index definition from an equivalent MyISAM or other table may not be supported.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-quick.html
First, you need to create a configuration directory such as /var/lib/mysql-cluster, by executing the following command as the system root user: $> mkdir /var/lib/mysql-cluster In this directory, create a file named config.ini that contains the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. However, it is not difficult in MySQL to create partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
--show-slave-auth-info Command-Line Format --show-slave-auth-info[={OFF|ON}] Type Boolean Default Value OFF Display replica user names and passwords in the output of SHOW SLAVE HOSTS on the source server for replicas started with the --report-user ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
DEFINER The account named in the DEFINER clause (often the user who created the routine), in 'user_name'@'host_name' format. If the routine has not been modified since its creation, this value is the same as the CREATED value. SQL_MODE The SQL mode ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
Is data decrypted for users who are authorized to see it? A.17.2. Is data decrypted for users who are authorized to see it? Yes. How do I know which data to encrypt? Compliance with the PCI-DSS standard requires that credit card numbers (Primary ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config-update-set-user.html
The sys_config_update_set_user trigger for the sys_config table is similar to the sys_config_insert_set_user trigger, but for UPDATE statements.