Use the Edit menu to make changes to objects. The text description for several of the menu items changes to reflect the name of the currently selected object.
This menu has items for cutting, copying, and pasting. These
actions can also be performed using the
Control+X, Control+C, and
Control+V key combinations. Undo a deletion using
the Undo Delete
object_name' item. The
Control+Z key combination can also be used to
undo an operation. It is also possible to carry out a
Redo operation using either the menu
item, or the key combination Control+Y.
Also find a Delete
object_name' menu item
for removing the currently selected object. The keyboard command
for this action is Control+Delete. You can also
right-click an object and choose the delete option from the pop-up
object_name' menu item
behaves differently depending upon circumstances. For example, if
an EER Diagram is active and a table on the
canvas is the currently selected object, a dialog box may open
asking whether you want to remove the table from the canvas only
or from the database as well. For information about setting the
default behavior when deleting from an EER Diagram, see
Section 5.3.5, “The Model Tab”.
MySQL Model page is active, the
selected object is deleted from the catalog and there will be
no confirmation dialog box.
Choose Edit Selected to edit the currently selected object. You can also perform edits in a new window by selecting Edit Selected in New Window. The keyboard shortcuts for Edit Selected and Edit Selected in New Window are Control+E and Control+Shift+E, respectively.
The Select item has the following submenus:
Select All (Keyboard shortcut, Control+A): Selects all the objects on the active EER diagram.
Similar Figures (Objects of the same type): Finds objects similar to the currently selected object.
Connected Figures: Finds all the objects connected to the currently selected object.
These menu items are active only when an EER Diagram tab is selected. The Similar Figures and the Connected Figures menu items are disabled if no object is currently selected on an EER diagram.
When multiple objects have been selected using one of these menu items, you can navigate between selected items by choosing the Go to Next Selected or Go to previous Selected menu item.
Selecting objects changes some of the Edit menu items. If only one object is selected, that object's name appears after the Cut, Copy and Delete menu items. If more than one object is selected, these menu items show the number of objects selected.
Each MySQL Workbench window includes search functionality. The Find panel with Find & Replace enabled is shown below:
The Find dialogue options are described below:
String Matching (default) or Regular Expression: Search by matching a string, or a PCRE regular expression.
Ignore Case: A case-insensitive search. Works with both the String Matching and Regular Expression search methods. Enabled by default.
Match Whole Words: If enabled, only whole strings are matched. For example, a search for "home" would not match "home_id". Disabled by default.
Wrap Around: The search will wrap around to the beginning of the document, as otherwise it will only search from the cursor position to the end of the document. Enabled by default.
And the arrows jump to the discovered search terms, and behave according to the Wrap Around option.
The MySQL Workbench Commercial edition includes an advanced Find facility for models:
You can search the following locations:
Entire Model: Searches the entire model.
Current View: Searches the current view only. This may be
MySQL Model page.
All Views: Searches the
MySQL Model Page
and all EER diagrams.
Database Objects: Searches database objects only.
Selected Figures: Searches the currently selected objects. This feature works only for EER diagrams.
Enter the text you wish to search for in the Find Text list. You may also select any or all of the following check boxes:
Use Regular Expression
Search in Comments
Search in SQL for Views, SPs etc.
Any text you enter into the Find Text list is retained for the duration of your session. Use the Next or Previous buttons to find occurrences of your search criterion.
Clicking the Find All button opens a Find Results window anchored at the bottom of the application. If you wish, you may undock this window as you would any other.
Use this window to navigate to objects. For example,
Description of an object
located on an EER diagram navigates to the specific diagram and
selects the object. Notice that the properties of the object are
displayed in the
Find dialog window can also be opened
using the Control+F key combination. Use
Control+G to find the next occurrence and
Control+Shift+G to find a previous occurrence.
Find dialog window by clicking the
x in the top right corner or by pressing
the Esc key.
This menu item enables you to set global preferences for the MySQL Workbench application.
For further information, see Section 5.3, “Workbench Preferences”.