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/information-schema-tables-table.html
CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Create_options shows the ENCRYPTION option specified when creating or altering a file-per-table tablespace. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. Create_options shows the row format that was specified in the CREATE TABLE ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
When you create a CSV table, the server creates a table format file in the database directory. The storage engine also creates plain text data file having a name that begins with the table name and has a .CSV extension. If you examine the test.CSV ... The CSV storage engine stores data in text files using comma-separated values ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-configuration.html
In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration files. (Create the file if it does not exist.) For example: $> vi /etc/my.cnf Note We show vi being used here to create the file, but ...For our four-node, four-host NDB Cluster (see Cluster nodes and host computers), it is necessary to write four configuration files, one per node ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. With --all-databases or --databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database. This ensures that when the dump file ...For information about reloading such dump files, see Section 7.4.2, “Reloading SQL-Format ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
Note In MySQL 5.7, all partitions of a partitioned table must have the same number of subpartitions, and it is not possible to change the subpartitioning once the table has been created. This clause has the same syntax as that as used with CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. 16.1.2.4.1 Creating a Data Snapshot Using mysqldump To create a snapshot of ... If the database on the source contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
The string must be a suitable length for the Primary Account Number, but is not otherwise checked. The string must be a suitable length for the Primary Account Number, but is not otherwise checked. Example: mysql> SELECT gen_rnd_email(); ...If a ...