Search Results
https://dev.mysql.com/doc/workbench/en/wb-generating-php.html
It is a SELECT statement, and optionally uses SET to set variables. This example will use the sakila database, with the query being: SET @last_update = '2006-02-14'; SELECT actor_id, first_name, last_name, last_update FROM actor WHERE last_update > ... MySQL Workbench can be used to generate PHP code with the bundled PHP plugin, by using the Tools, Utilities, Copy as PHP Code menu ...
https://dev.mysql.com/doc/workbench/en/wb-keys.html
The following tables list keyboard shortcuts for MySQL Workbench commands.
https://dev.mysql.com/doc/workbench/en/wb-manage-server-connections.html
This dialog is invoked by either clicking the manage connections icon () on the home screen or by selecting Database and then Manage Connections from the main menu. This connection can then be selected from a list in other wizards requiring a ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mysql.html
To open the wizard, select Database and then Schema Transfer Wizard from the main menu. Figure 10.46 MySQL Schema Transfer Wizard: Connection Selection Choose your target and source MySQL connections (see the figure that follows). Figure 10.47 MySQL ... Perform MySQL server version upgrades to move off older MySQL versions to the latest ...
https://dev.mysql.com/doc/workbench/en/wb-model-reporting.html
The DBDoc - Model Reporting dialog is found by opening a model, selecting Model from the menu, and then DBDoc - Model Reporting. For example, the following figure shows the dialog with HTML Detailed Frames selected and the template style set to ...
https://dev.mysql.com/doc/workbench/en/wb-modifying-layer.html
When you select a layer on the EER Diagram canvas, its properties are displayed in the Properties palette. Select the layer and, in the Properties palette, set the visible property to False. To locate an invisible object, open the Layers palette and ... Choosing "Edit" allows you to edit the layer name and layer background color, and the "Properties Editor" offers additional edit ...
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
Visual Explain Usage To view a visual explain execution plan, execute your query from the SQL editor and then select Execution Plan within the query results tab. The visual explain feature generates and displays a visual representation of the MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-routines.html
Do this by selecting a role and then clicking the < button. Use the Shift key to select multiple contiguous roles and the Control key to select noncontiguous roles. The privileges that display are: ALL CREATE DROP GRANT OPTION REFERENCES ALTER ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-snippets.html
Optionally, you can edit this file outside of MySQL Workbench or create new files that will also be listed under the snippets selector. For example, adding a file named "More Snippets.txt" will add a "More Snippets" section to the snippets selection ... The Snippets secondary tab includes built-in, local, and shared custom ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
The actions available to you depend on which tab is selected when you click a menu. The Information area provides the Object Info and Session subtabs, which include read-only information about a selected object and about the active connection. The ...