Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
Warning Changing privileges and permissions improperly on MySQL can potentially cause your server installation to have non-optimal security properties. This section explains the symptoms and resolutions for the most commonly encountered issues with ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core.html
optionsBuilder.UseMySQL("server=localhost;database=library;user=user;password=password"); } Limitations The Connector/NET implementation of EF Core has the following limitations: Memory-Optimized Tables is not supported. MySQL Connector/NET ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework60.html
DbSet.AddRange/RemoveRange provides an optimized way to add or remove multiple entities from a set. MySQL Connector/NET integrates support for Entity Framework 6 (EF6), which now includes support for cross-platform application deployment with the ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
When you extend and optimize the queries in a stored procedure, all the applications that call the procedure automatically receive the benefits. A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-installation-binary-windows-debug.html
The associated Debug files are bundled in its own Zip file, including two lib/ directories: lib/: PDB files to use with regular builds; they are built in RelWithDebInfo mode. Debug/lib/: Debug builds built in Debug mode; includes driver, PDB files, ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-api.html
SQLSpecialColumns Yes X/Open Returns information about the optimal set of columns that uniquely identifies a row in a specified table, or the columns that are automatically updated when any value in the row is updated by a transaction. For the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-support-version-history.html
At installation time, you can choose the Unicode driver for the broadest compatibility with data sources using various character sets, or the ANSI driver for optimal performance with a more limited range of character sets. This section highlights ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-borland.html
With all Borland applications where the Borland Database Engine (BDE) is used, follow these steps to improve compatibility: Update to BDE 3.2 or newer. 5.8.2.2.1 Using Connector/ODBC with Borland Builder 4 When you start a query, you can use the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-performance.html
The Connector/ODBC driver has been optimized to provide very fast performance. If you experience problems with the performance of Connector/ODBC, or notice a large amount of disk activity for simple queries, there are a number of aspects to check: ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-executemany.html
An optimization is applied for inserts: The data values given by the parameter sequences are batched using multiple-row syntax. Syntax: cursor.executemany(operation, seq_of_params) This method prepares a database operation (query or command) and ...