Search Results
https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-creating-a-model.html
This tutorial describes how to create a new database model and how to forward-engineer a model to a live MySQL server. Note Alternatively, you can create a model from a database by using the reverse engineering wizard. For additional information, ...
https://dev.mysql.com/doc/workbench/en/wb-grt-data-organization.html
The Generic RunTime (GRT) is the internal system used by MySQL Workbench to hold model document data. It is also the mechanism by which Workbench can interact with Modules and Plugins. Workbench model data, such as diagrams, schemas, and tables, is ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html
General Information Microsoft Windows is required because Microsoft Access ODBC drivers are only available on Windows. As for the destination MySQL server, you can have it in the same local machine or elsewhere in your network. Preparing a Microsoft ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
Typically this occurs where an intermediary table is created to resolve a many-to-many relationship. In such cases, the primary key is usually a composite key made up of the primary keys from the two original tables. A non-identifying relationship: ...
https://dev.mysql.com/doc/workbench/en/wb-routines.html
9.1.6.1.1 Adding Routines to the Physical Schemata To add a routine, double-click the Add Routine icon in the Physical Schemata section of the MySQL Model page. If a routine with this name already exists, the new routine is named routine2. Adding a ...
https://dev.mysql.com/doc/workbench/en/wb-scripting-modules-palettes.html
The Workbench Scripting Shell features the Files, Globals, Classes, Modules, and Notifications tabs, in addition to the main Shell tab. Files Tab The Files tab lists folders and files for user-defined (custom) script files. The file-browser ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
Use the Columns subtab to display and edit all the column information for a table. You can also use the Columns subtab to change column properties such as name, data type, and default value. Figure 8.14 The Columns Tab Right-click a row under the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL Connector/J. Questions 3.14.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-entity-framework-databinding-linq-entities.html
In this tutorial you create an ASP.NET web page that binds LINQ queries to entities using the Entity Framework mapping with MySQL Connector/NET. If you have not already done so, install the world database sample prior to attempting this tutorial.