Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-clientflag.html
>>> import mysql.connector >>> mysql.connector.ClientFlag.FOUND_ROWS 2 See Section 10.2.32, “MySQLConnection.set_client_flags() Method” and the connection argument client_flag. This class provides constants defining MySQL client flags that can ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-custom-error-exception.html
import mysql.connector from mysql.connector import errorcode # Server error 1028 should raise a DatabaseError mysql.connector.custom_error_exception(1028, mysql.connector.DatabaseError) # Or using a dictionary: ... Syntax: ...
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-coding.html
Because MySQL often deals with data sets that are many times larger than available memory, techniques that optimize storage space and disk I/O are especially important. This is especially important for columns that make up the primary key for an ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html
The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 and print their names and hire dates to the console. We then create a new ...
https://dev.mysql.com/doc/connector-python/en/connector-python-verification.html
Verify the C-extension To verify the C-extension of the classic package is available, run this command: $ python -c "import mysql.connector; assert mysql.connector.HAVE_CEXT; print(f'C-ext is {mysql.connector.HAVE_CEXT}')" If no error is returned, ... Verifying Installations by pip To verify that a Connector/Python package has been installed successfully using pip, use the following command: $ pip install list If you have installed the classic interface, you should see an output similar to the following: Package Version ---------------------------------------- ---------- ...
https://dev.mysql.com/doc/internals/en/floating-point-types.html
I left out some important stuff around limit checking just to show the idea. The MySQL Reference Manual has a discussion of floating-point numbers in Section 11.2 Numeric Types, including details about the storage. Let us now take up the story from ...
https://dev.mysql.com/doc/internals/en/implementing-info-method.html
For this reason it is important to return a value of two or greater when you do not actually know how many rows are in the table before you perform the table scan (such as in a situation where the data may be externally populated). Prior to ...
https://dev.mysql.com/doc/internals/en/netware-directory.html
(.def is a common filename extension for "definition".) The three *.sql files are short scripts of SQL statements used in testing.
https://dev.mysql.com/doc/internals/en/x-protocol-implementation-implementation-notes.html
Topics in this section: Client Server Client and Server implementations of the protocol should make use of the following: vectorized IO pipelining to reduce the latency and CPU usage. Client Out-of-Band Messages The client should decode the ...