Search Results
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT statements. The following common methods are for generating SQL statements in MySQL Workbench. Note All of the MySQL Workbench Export options include ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. TABLE not migrated There is not ...SMALLINT SMALLINT BIGINT BIGINT BIT TINYINT(1) FLOAT FLOAT Precision value is used for storage size in ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-generic.html
In this case, code objects will not be retrieved from the source database; only tables and data. When using the generic support, column data types are mapped using the following steps: It searches for the first entry in the Generic Datatype Mapping ... Most ODBC compliant databases may be migrated using the generic database ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-data-migration-setup.html
The setup screen includes the following options: Data Copy: Online copy of table data to target RDBMS: This (default) will copy the data to the target RDBMS. Options: Truncate target tables before copying data: In case the target database already ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-object-selection.html
Valid objects include Table, View, and Routine objects, with only the Table objects being selected by default (see the figure that follows). Use the Show Selection button in order to disable individual table objects from being migrated. Objects ...
https://dev.mysql.com/doc/workbench/en/wb-using-layer-tool.html
Create a layer by clicking anywhere on the EER Diagram canvas and, while holding the left mouse button down, draw a rectangle of a suitable size. The available context-menu options are: Cut 'layer_name' Copy 'layer_name' Paste 'a_table_name' Edit ...
https://dev.mysql.com/doc/connectors/en/connector-j-support-bug-report.html
If you have a repeatable bug report, please report it to the bugs database at http://bugs.mysql.com/. If at all possible, create a repeatable, standalone testcase that doesn't involve any third-party classes. In the setUp() method, create code that ... The normal place to report bugs is http://bugs.mysql.com/, which is the address for our bugs ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework60.html
For this option, select nuget.org as the package source, search for mysql.data, and install a stable version of MySql.Data.EntityFramework. Configurable Migrations History Table allows you to customize the definition of the migrations history table.
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-reading.html
After a file is loaded into the file table, we can use the MySqlDataReader class to retrieve it. The GetBytes method of the MySqlDataReader is used to load the BLOB into a byte array, which is then written to disk using a FileStream object. The ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-data-adapter.html
It is also possible to work in a manner where a connection is only established when needed. For example, in this mode, a connection could be established to read a chunk of data, the data could then be modified by the application as required. A ...