Search Results
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 ...
https://dev.mysql.com/doc/connectors/en/connector-python-introduction.html
You can turn automatic conversion on for convenience, or off for optimal performance. MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249). For notes detailing the changes in each release of Connector/Python, see MySQL Connector/Python Release ...
https://dev.mysql.com/doc/connector-net/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/connector-net/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/connector-net/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/connector-odbc/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/connector-odbc/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/connector-odbc/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/connector-odbc/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.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualobjects.html
Select the Don't optimize column widths option. ...