Search Results
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html
If not, MySQL Workbench will display a "read-only" icon at the bottom-right corner of the SQL View panel, and hovering the mouse cursor over this icon will provide a hint as to why it's not editable. The SQL query secondary tab opens by default ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
This section summarizes many of the new features added to MySQL Workbench 6.2, in relation to the MySQL Workbench 6.1 release. Overlay Icons in the Object Viewer The schema navigator now includes shortcut buttons for common operations such as table ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
This limitation is particularly relevant when using data streaming: after the failover, the ResultSet looks to be alright, but the underlying connection may have changed already, and no backing cursor is available anymore. A failover happens when ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-windows-5-2.html
Figure 5.5 Connector/ODBC Connect Options Dialog Toggling the Details button opens (or closes) an additional tabbed display where you set additional options that include the following: Connections, Metadata, and Cursors/Results enable you to select ... The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
The GetChunk() and AppendChunk() methods from ADO do not work as expected when the cursor location is specified as adUseServer. The following section details some common errors and their suggested fix or alternative solution. If you are still ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-programmingerror.html
The following example shows how to handle syntax errors: try: cursor.execute("CREATE DESK t1 (id int, PRIMARY KEY (id))") except mysql.connector.ProgrammingError as err: if err.errno == errorcode.ER_SYNTAX_ERROR: print("Check your syntax!") else: ...
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, ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-rollback.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.rollback() To commit modifications, see the commit() method. This method sends a ROLLBACK statement to the MySQL server, undoing all data changes ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-clear-attributes.html
Syntax: cursor.clear_attributes() Clear the list of query attributes on the connector's side, as set by Section 6.9.5.2, “MySQLCursor.add_attribute() Method”.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-fetchmany.html
Syntax: rows = cursor.fetchmany(size=1) This method fetches the next set of rows of a query result and returns a list of tuples. If no more rows are available, it returns an empty list. The number of rows returned can be specified using the size ...