Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-programmingerror.html
This exception is raised on programming errors, for example when you have a syntax error in your SQL or a table was not found. The following example shows how to handle syntax errors: try: cursor.execute("CREATE DESK t1 (id int, PRIMARY KEY (id))") ...
https://dev.mysql.com/doc/connectors/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
This chapter describes the full set of MySQL Connector/NET 8.0 connection options. The protocol you use to make a connection to the server (classic MySQL protocol or X Protocol) determines which options you should use. Connection options have a ...
https://dev.mysql.com/doc/connector-net/en/connector-net-interceptors.html
An interceptor is a software design pattern that provides a transparent way to extend or modify some aspect of a program, similar to a user exit. With MySQL Connector/NET, the interceptors are enabled and disabled by updating the connection string ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-authentication-user-plugin.html
Advanced users with special security requirements can create their own authentication plugins for MySQL Connector/NET applications. For background and usage information about MySQL authentication plugins, see Authentication Plugins and Writing ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-bulk-loader.html
MySQL Connector/NET features a bulk loader class that wraps the MySQL statement LOAD DATA INFILE. This gives Connector/NET the ability to load a data file from a local or remote host to the server, or a stream to a database (from Connector/NET ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
This section describes how to set up your application to view MySQL trace information. The first thing you need to do is create a suitable app.config file for your application. The switch level in this case is set to Verbose to display the maximum ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
When a connection has been established with the MySQL database, the next step enables you to perform database operations. This task can be achieved through the use of the MySqlCommand object. After it has been created, there are three main methods ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-vb.html
The following sample creates a table my_vb_net and demonstrates the use in VB.