Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-store-result.html
By default, result sets for successfully executed prepared statements are not buffered on the client and mysql_stmt_fetch() fetches them one at a time from the server. int mysql_stmt_store_result(MYSQL_STMT *stmt) Description Result sets are ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-features-connection-sharing.html
MySQL Router enables server connections to be pooled and shared. If the client connection is idle for more than a specified time, the server connection idles until a new client connection is established. MySQL Router tracks the statements executed ...If a client disconnects, the server connection is moved to the connection pool, where it is available for ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-instance-startup-shutdown.html
The Administration - Startup / Shutdown tab enables you to perform the following service-control actions: View the Startup Message Log. With a valid connection established, and the connection tab for it open, you can access the control actions from ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-status-variables.html
The Administration - Status and System Variables secondary tab lists the full set of server variables for the active MySQL connection. Figure 6.9 Navigator Administration: System Variables Persist System Variables Beginning with MySQL Workbench ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-remote-management.html
The Remote Management tab is available when connecting to MySQL remotely, as the following figure shows. To access this tab, select a remote connection from the MySQL Connections pane or click New to create a new connection.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-buffered.html
Syntax: is_buffered = ccnx.buffered() # getter ccnx.buffered(bool) # setter With no argument, returns True or False to indicate whether the MySQL instance buffers (stores) the results. For the setter syntax, raises a TypeError exception if the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-connect.html
import _mysql_connector ccnx = _mysql_connector.MySQL() ccnx.connect(user='scott', password='password', host='127.0.0.1', database='employees') ccnx.close() connect() supports the following arguments: host, user, password, database, port, ...If ccnx ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-fields.html
Returns a list of tuples, one tuple per column Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: field_info = ccnx.fetch_fields() Fetches column information for the active result set.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-row.html
ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ccnx.fetch_row() print(row) ccnx.free_result() Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: row = ccnx.fetch_row() Fetches the next row from ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-next-result.html
Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: ccnx.next_result() Initiates the next result set for a statement string that produced multiple result sets.