Search Results
https://dev.mysql.com/doc/connector-net/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 schema information is returned in the form of a DataTable. Different forms of the GetSchema() method can be ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tablecaching.html
Table caching is a feature that can be used to cache slow-changing datasets on the client side. This is useful for applications that are designed to use readers, but still want to minimize trips to the server for slow-changing tables. This feature ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming.html
MySQL Connector/NET comprises several classes that are used to connect to the database, execute queries and statements, and manage query results. The following are the major classes of Connector/NET: MySqlConnection: Represents an open connection ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-general-information.html
ODBC (Open Database Connectivity) provides a way for client programs to access a wide range of databases or data sources. ODBC is a standardized API that enables connections to SQL database servers. It was developed according to the specifications ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-source-unix-macos.html
To build Connector/ODBC from source on macOS, follow the same instructions given for Section 4.5, “Building Connector/ODBC from a Source Distribution on Unix”. Notice that iODBC is the default ODBC library used when building Connector/ODBC on ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference.html
This section provides reference material for the Connector/ODBC API, showing supported functions and methods, supported MySQL column types and the corresponding native type in Connector/ODBC, and the error codes returned by Connector/ODBC when a ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-borland-builder.html
When you start a query, you can use the Active property or the Open method. The Active property starts by automatically issuing a SELECT * FROM ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
To improve the integration between Microsoft Access and MySQL through Connector/ODBC: For all versions of Access, enable the Connector/ODBC Return matching rows option. Include a TIMESTAMP column in all tables that you want to be able to update.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips.html
Most programs should work with Connector/ODBC, but for each of those listed here, there are specific notes and tips to improve or enhance the way you work with Connector/ODBC and these applications. With all applications, ensure that you are using ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. For example, ...