Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualinterdev.html
If you have a BIGINT in your result, you may get the error [Microsoft][ODBC Driver Manager] Driver does not support this parameter. Try selecting the Change BIGINT columns to INT option in the Connector/ODBC connect screen.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-integrityerror.html
This exception is raised when the relational integrity of the data is affected. For example, a duplicate key was inserted or a foreign key constraint would fail. The following example shows a duplicate key error raised as IntegrityError: ...
https://dev.mysql.com/doc/connector-python/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/connector-python/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/internals/en/com-change-user.html
COM_CHANGE_USER changes the user of the current connection and reset the connection state. and others It is followed by the same states as the initial handshake.
https://dev.mysql.com/doc/internals/en/com-query-response.html
Image description If it is not a valid Protocol::LengthEncodedInteger it is either a ERR_Packet or a Protocol::LOCAL_INFILE_Request. Image description 14.6.4.1.1 Text Resultset A Text Resultset is a possible COM_QUERY Response. It is made up of two ...
https://dev.mysql.com/doc/internals/en/compressed-payload.html
If the length of payload before compression is more than 0 the Compressed Packet header is followed by the compressed payload. It uses the deflate algorithm as defined in RFC 1951 and implemented in zlib. The header of the compressed packet has the ...
https://dev.mysql.com/doc/internals/en/delete-row.html
Synopsis virtual int delete_row ( buf); const byte * buf ; Description This is the delete_row method. buf will contain a copy of the row to be deleted. The server will call this right after the current row has been called (from either a previous ...
https://dev.mysql.com/doc/internals/en/extra.html
Purpose Passes hints from the server to the storage engine. Synopsis virtual int extra ( operation); enum ha_extra_function operation ; Description This is the extra method. extra() is called whenever the server wishes to send a hint to the storage ...