MySQL :: MySQL Workbench Manual

Search Results

Displaying 51 to 60 of 66 total results

https://dev.mysql.com/doc/workbench/en/wb-develop-object-management-inspector.html

Figure 8.23 Schema Inspector Each tab lists topic-oriented information in categories, such as tables, indexes, and triggers. The Table Inspector includes an easy-to-use interface for analyzing and creating indexes for your tables. The Schema ...

9.1.3.2 Adding Tables to an EER Diagram

https://dev.mysql.com/doc/workbench/en/wb-using-table-tool.html

Figure 9.15 A Table on an EER Diagram As shown in the preceding figure, the primary key is indicated by a key icon and indexed fields are indicated by a different colored diamond icon. Toggle the display of indexes and triggers in the same way.

9.7.2 Creating a Custom Template

https://dev.mysql.com/doc/workbench/en/dbdoc-templates-custom.html

In the simplest case, a template consists of two files: a template file, which has a .tpl extension, and a special file info.xml. A third file is optional, which is the preview image file. This preview file provides a thumbnail image illustrating ...

Chapter 1 General Information

https://dev.mysql.com/doc/workbench/en/wb-intro.html

The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. This chapter provides general information about MySQL Workbench and how it has ...

Chapter 11 MySQL HeatWave Migration Assistant

https://dev.mysql.com/doc/workbench/en/heatwave-migration-assistant.html

This amount must be large enough to contain the database tables, indexes, objects, redo log, binary logs, and other internal data. The MySQL HeatWave Migration Assistant allows you to migrate on-premises databases to MySQL HeatWave DB Systems in ...

6.5.3 Result Data Export and Import

https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-results.html

Note The result set must have a unique row identifier (such as a Primary Key or NOT NULL unique index) as otherwise values cannot be imported because the result set will be read-only. Export or Import data directly from or into the result set. The ...

9.3.4.1 Creating a New Table

https://dev.mysql.com/doc/workbench/en/wb-create-new-table.html

Altering the table by adding indexes or other features is also possible using the table editor by clicking each tab within the table editor. Create a new table by double-clicking the Add Table icon in the Physical Schemas panel, as the next figure ...

9.1.1.5 The Schema Privileges Panel

https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html

The following figure shows the film table object from the sakila schema with INDEX, INSERT, SELECT, and TRIGGER selected for the role1 role. The Schema Privileges panel has the following sections, used to create users for your schemas and to define ...

9.2.3 Schema Validation Plugins

https://dev.mysql.com/doc/workbench/en/wb-validation-plugins.html

MySQL Workbench provides validation modules so that you can test your models before implementing them. The validation (MySQL) plugins are accessed from the Model menu within an open MySQL Model or EER Diagram tab. Beneath the menu item are a number ...

9.1.6.1 Routines

https://dev.mysql.com/doc/workbench/en/wb-routines.html

The privileges that display are: ALL CREATE DROP GRANT OPTION REFERENCES ALTER DELETE INDEX INSERT SELECT UPDATE TRIGGER You can choose to assign all privileges to a specific role or any other privilege as listed previously. 9.1.6.1.1 Adding ...

Displaying 51 to 60 of 66 total results