Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-with-rows.html
Syntax: boolean = cursor.with_rows This read-only property returns True or False to indicate whether the most recently executed operation could have produced rows. The with_rows property is useful when it is necessary to determine whether a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursordict.html
Example: cnx = mysql.connector.connect(database='world') cursor = cnx.cursor(dictionary=True) cursor.execute("SELECT * FROM country WHERE Continent = 'Europe'") print("Countries in Europe:") for row in cursor: print("* ...The keys for each ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext-module.html
To use the C Extension directly, import the _mysql_connector module rather than mysql.connector, then use the _mysql_connector.MySQL() class to obtain a MySQL instance. For example: import _mysql_connector ccnx = _mysql_connector.MySQL() ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext-reference.html
This chapter contains the public API reference for the Connector/Python C Extension, also known as the _mysql_connector Python module. The _mysql_connector C Extension module can be used directly without any other code of Connector/Python. Note ...
https://dev.mysql.com/doc/connector-python/en/connector-python-coding.html
The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to developers coming from a Python background: For security, do not hardcode the values needed to connect and log into the database in ...
https://dev.mysql.com/doc/connector-python/en/connector-python-examples.html
These coding examples illustrate how to develop Python applications and scripts which connect to MySQL Server using MySQL Connector/Python.
https://dev.mysql.com/doc/connector-python/en/connector-python-reference.html
mysql.connector errorcode errors connection constants conversion cursor dbapi locales eng client_error protocol utils . Examples should be considered working for Python 2.7, and Python 3.1 and greater. They might also work for older versions (such ...
https://dev.mysql.com/doc/connector-python/en/connector-python-tutorials.html
These tutorials illustrate how to develop Python applications and scripts that connect to a MySQL database server using MySQL Connector/Python.
https://dev.mysql.com/doc/internals/en/auth-phase-fast-path.html
Now, dependign on the authentication method, further authentication data can be exchanged until server either refuses or accepts connection. Assume that client wants to log in as user U and that user account uses authentication method M. The fast ...
https://dev.mysql.com/doc/internals/en/authentication-after-com-change-user-command.html
Eventually server will accept new account with OK_Packet and resume the command phase or it will reject change with ERR_Packet and disconnect. During Command Phase, a client can send a COM_CHANGE_USER command which will trigger logging into a new ...