Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-table-status.html
Create_options shows the ENCRYPTION clause for file-per-table tablespaces if the table is encrypted or if the specified encryption differs from the schema encryption. The encryption clause is not shown for tables created in general tablespaces. When ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-type-overview.html
For other examples showing how to use spatial data types in MySQL, see Section 13.4.6, “Creating Spatial Columns”. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The ...
https://dev.mysql.com/doc/refman/9.7/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.27, “CREATE VIEW Statement”). A view can be created from many kinds of SELECT statements. To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.13, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-incremental-options.html
This is potentially the fastest way for mysqlbackup to create incremental backups. --incremental-with-redo-log-only Specifies that an incremental backup is to be created using only the redo log. This alternate type of incremental backup has ... For ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-repository-options.html
When the --with-timestamp option is also specified, an additional level of subdirectory, with the timestamp in its name, is created under --backup-dir (see description for the --with-timestamp option for details). When restoring a single-file backup ... These options specify various parameters related to the backup image or directory, or to how the backup will be ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/replicaset-adopting.html
As an alternative to creating a ReplicaSet from scratch, you can adopt an existing replication setup using the adoptFromAR option with dba.createReplicaSet(). The replication setup is scanned, and if it is compatible with the InnoDB ReplicaSet ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/upgrade-mysql-clusterset.html
On a Unix system, if you used the optional --directory bootstrap option, a self-contained installation is created with all generated directories and files at the location you selected when you bootstrapped the router. Navigate to this directory and ... To upgrade the server instances in an InnoDB ClusterSet, complete the following steps: Upgrade MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
For all of the other database samples, such as world or employee data, you must create the MySQL Workbench (.mwb) file first before you can view the database objects in a model or add an EER diagram for it. To create a MySQL Workbench model file for ... MySQL Workbench represents each active data model as an icon in the models view of the home screen ...
https://dev.mysql.com/doc/workbench/en/wb-eer-diagram-editor.html
Enhanced Entity-Relationship (EER) diagrams are created by double-clicking Add Diagram in the Model Editor. You may create any number of EER diagrams just as you may create any number of physical schemas (databases). Note This tool is for creating ...Clicking an EER diagram tab navigates to the canvas used for graphically manipulating database ...
https://dev.mysql.com/doc/workbench/en/wb-home.html
For more information, see Chapter 5, Connections in MySQL Workbench and Section 5.2, “Creating A New MySQL Connection (Tutorial)”. Create a group by either right-clicking a connection and choosing the Move to group context menu option, or you ...