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-api-mysqlconnection-cmd-process-info.html
Instead, use the SHOW PROCESSLIST statement or query the tables found in the database INFORMATION_SCHEMA.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-refresh.html
This method flushes tables or caches, or resets replication server information. The options argument should be a bitmask value constructed using constants from the constants.RefreshOption class. Example: >>> from mysql.connector import RefreshOption ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-statistics.html
Returns a dictionary containing information about the MySQL server including uptime in seconds and the number of running threads, questions, reloads, and open tables.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-commit.html
Since by default Connector/Python does not autocommit, it is important to call this method after every transaction that modifies data for tables that use transactional storage engines. This method sends a COMMIT statement to the MySQL server, ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-lastrowid.html
For example, if you perform an INSERT into a table that contains an AUTO_INCREMENT column, lastrowid returns the AUTO_INCREMENT value for the new row. Syntax: id = cursor.lastrowid This read-only property returns the value generated for an ...
https://dev.mysql.com/doc/connector-net/en/connector-net-asp-provider.html
Connector/NET supports the following web providers: Membership provider Roles provider Profiles provider Session state provider The following tables show the supported providers, their default provider and the corresponding MySQL provider. MySQL ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-binary-issues.html
When a temporary table is used to process a result set, some columns may be returned with incorrect binary flags. There are certain situations where MySQL will return incorrect metadata about one or more columns. More specifically, the server can ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-crystal-source.html
You will be able to browse your database and choose tables and fields using drag and drop to build your report. When creating a report in Crystal Reports there are two options for accessing the MySQL data while designing your report. The first ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
The first thing you need to do is create a suitable app.config file for your application. This section describes how to set up your application to view MySQL trace information. The switch level in this case is set to Verbose to display the maximum ...