Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-YEAR.html
Connector/J follows the same rules that govern how values are inserted by a mysql client; see explanations in The YEAR Type for details. How a value in a MySQL YEAR column is handled is controlled by the connection property yearIsDateType: If ...
https://dev.mysql.com/doc/connectors/en/connector-net-authentication.html
MySQL Connector/NET implements a variety of authentication plugins that MySQL Server can invoke to authenticate a user. Pluggable authentication enables the server to determine which plugin applies, based on the user name and host name that your ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core-example.html
Insert the following code into the existing Program.cs file, replacing the default C# code. The Code First approach enables you to define an entity model in code, create a database from the model, and then add data to the database. MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-mysqlcommand.html
Class methods enable you to perform the following database operations: Query a database Insert, update, and delete data Return a single value Command-based database operations can run within a transaction, if needed. The MySqlCommand class ...
https://dev.mysql.com/doc/connectors/en/connector-net-using-character-sets.html
To insert 4-byte UTF8 strings into blob columns, use the .NET Encoding.GetBytes function to convert your string to a series of bytes. Treating Binary Blobs As UTF8 Before the introduction of 4-byte UTF-8 character set, MySQL did not support 4-byte ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-architecture.html
The database is used as the source of the data (during queries) and the destination for data (during inserts and updates). The Connector/ODBC architecture is based on five components, as shown in the following diagram: Figure 5.1 Connector/ODBC ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-overview.html
For Delete / Update / Insert the results might include the number of rows affected. Interacting with a MySQL server from an applications using the Connector/ODBC typically involves the following operations: Configure the Connector/ODBC DSN. This ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-crystalreports.html
Open Crystal Reports and create a new project, or an open an existing reporting project into which you want to insert data from your MySQL data source. Crystal Reports can use an ODBC DSN to connect to a database from which you to extract data and ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
The majority of Microsoft applications have been tested with Connector/ODBC, including Microsoft Office, Microsoft Access and the various programming languages supported within ASP and Microsoft Visual Studio. 5.8.2.1.1 Microsoft Access To improve ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-commit.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.commit() To roll back instead and discard modifications, see the rollback() method. This method sends a COMMIT statement to the MySQL server, ...