MySQL :: MySQL Workbench Manual

Search Results

Displaying 51 to 60 of 66 total results

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 ...

10.3 Conceptual DBMS Equivalents

https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html

Index Yes Yes Yes Yes Information Schema Yes No Yes Yes Object Names Case Sensitivity Depends on collation Depends on collation Mixed Mixed MySQL: sensitivity of database, table, and trigger names OS dependent; other object names are not ... The ...

10.4 Microsoft Access Migration

https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html

At this point, the migration wizard is retrieving relevant information about the involved database objects (such as table names, table columns, primary and foreign keys, indexes, triggers, views, and more). General Information Microsoft Windows is ...

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 ...

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 ...

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 ...

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 ...

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 ...

6.5.2 SQL Data Export and Import Wizard

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

The next figure shows an example that adds table locks, uses replace instead of insert statements, quotes identifiers with backtick characters, and so on. Use this wizard to either export or import SQL generated from MySQL Workbench or with the ...

9.4.1.2 Forward Engineering to a Live Server

https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-live-server.html

Figure 9.45 Forward Engineering Progress You can confirm that the script created the schema by connecting to the target MySQL server and issuing a SHOW DATABASES statement. Use forward engineering to export your schema design to a MySQL server.

Displaying 51 to 60 of 66 total results