Search Results
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineering.html
With MySQL Workbench, you can reverse-engineer a database using a MySQL create script or you can connect to a live MySQL server and import a single database or a number of databases.
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
Select "Microsoft Access" as your source database in the wizard, use MySQL as your target source database, and then execute. The migration wizard can now resume operation if a data copy failed during a database migration from, for example, a timeout ... This section summarizes many of the new features added to MySQL Workbench 6.2, in relation to the MySQL Workbench 6.1 ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-connect-drivermanager.html
With this method, you could use an external configuration file to supply the driver class name and driver parameters to use when connecting to a database. } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
In practice, when a thread needs to do work against a MySQL or other database with JDBC, it requests a connection from the pool. Although this is not usually an issue with the quick connection setup that MySQL offers compared to other databases, ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-connpooling.html
In many situations, such as web applications, there will be a large number of small database transactions. When this is the case, it usually makes sense to create a pool of database connections available for web requests as needed. The difference ...Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to create and set up the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
To use transactional database access, we will need to change the storage engine of the tables in the world database. First you create a simple interface: public interface Ex3Dao { Integer createCity(String name, String countryCode, String district, ... Spring allows us to add transactions into our code without having to deal directly with the JDBC ...
https://dev.mysql.com/doc/connectors/en/connector-net-asp-provider.html
There is no need to run any type of SQL script to set up the database schema, as the providers create and maintain the proper schema automatically. You do this by first removing the dummy connection string and then adding in the proper one, as shown ... MySQL Connector/NET includes a provider model for use with ASP.NET ...
https://dev.mysql.com/doc/connectors/en/connector-net-installation-binary-nuget.html
In addition, the packages provides access to multiple versions of MySQL server and encapsulates database-specific protocols. MySql.Data.EntityFramework This package provides object-relational mapper (ORM) capabilities, which enables you to work with ... MySQL Connector/NET functionality is available as packages from NuGet, an open-source package manager for the Microsoft development platform (including .NET ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-getschema.html
The GetSchema() method of the connection object can be used to retrieve schema information about the database currently connected to. The following are the collections currently provided by Connector/NET, in addition to the common collections shown ...The schema information is returned in the form of a ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
mysql Information: 1 : 1: Connection Opened: connection string = 'server=localhost;User Id=root;database=world;port=3306 ;password=******;logging=True' mysql Information: 3 : 1: Query Opened: SHOW VARIABLES mysql Information: 4 : 1: Resultset ...