MySQL :: MySQL Workbench Manual

Search Results

Displaying 51 to 60 of 66 total results

9.1.3.1 Adding Tables to the Physical Schemas

https://dev.mysql.com/doc/workbench/en/wb-tables-physical-schemata.html

Copy SQL to Clipboard: Copies a CREATE TABLE statement for the table. Copy Insert to Clipboard: Copies INSERT statements based on the model's inserts. Copy Insert Template to Clipboard: Copies a generic INSERT statement that is based on the model.

8.1.1 SQL Query Tab

https://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html

You can enter SQL statements directly into the query editor area. The statements entered can be saved to a file or snippet for later use. At any point, you can also execute the statements you have entered. The SQL query secondary tab opens by ...

1.1.2.1 New in MySQL Workbench 6.3

https://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html

SQL Editor Auto-Completion The SQL editor auto-completion improvements include the following changes: It now functions with all statement types, when before only SELECT statements were fully supported. This new wizard does not require an executed ...

8.1.11.2 Generating PHP Code

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

It is a SELECT statement, and optionally uses SET to set variables. SQL @variables generate PHP variables in the code that then bind to the statement before execution. MySQL Workbench can be used to generate PHP code with the bundled PHP plugin, by ...

3.2.2 SQL Editor Preferences

https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html

When selected, this preference makes it possible to catch UPDATE and DELETE statements with keys that are not used properly and that can probably accidentally change or delete a large number of rows. This section provides configuration options that ...

8.1.10.7 Options Tab

https://dev.mysql.com/doc/workbench/en/wb-table-editor-options-tab.html

See CREATE TABLE Statement for more information on how to use these options. You may specify the action the server should take when users attempt to perform INSERT statements on the merge table. The Options subtab enables you to set several types ...

7.1 Performance Dashboard

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

Data points include the Table Open Cache efficiency, SQL Statements Executed, and counts (per second) for SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP statements. To display the dashboard, open a query tab and then click Dashboard from ...

C.2 Modules

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

Modules can be imported in Python using statements such as from grt.modules import WbModel. For the export statement, the return type is listed first, followed by the input parameter types, specified as GRT typenames. In the GRT Modules are ...

1.1.2.2 New in MySQL Workbench 6.2

https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html

This section summarizes many of the new features added to MySQL Workbench 6.2, in relation to the MySQL Workbench 6.1 release. Overlay Icons in the Object Viewer The schema navigator now includes shortcut buttons for common operations such as table ...

5.4 Client Connections

https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-client-connections.html

The client connection browser lists the active and sleeping MySQL client connections, and adds the ability to kill statements and connections, and view additional connection details and attributes. The following figure shows an example of client ...

Displaying 51 to 60 of 66 total results