Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursordict.html
The keys for each dictionary object are the column names of the MySQL result. Example: cnx = mysql.connector.connect(database='world') cursor = cnx.cursor(dictionary=True) cursor.execute("SELECT * FROM country WHERE Continent = 'Europe'") ...
https://dev.mysql.com/doc/internals/en/binlog-row-image.html
To specify the sets of columns, we define the PKE (for Primary Key Equivalent), as follows: If a PK exists, the PKE is equal to the PK. Status of this subsection: finished, not reviewed, not fully implemented 2009-10-21 The sets of columns recorded ...
https://dev.mysql.com/doc/internals/en/charsets.html
Character sets are used by MySQL when storing information, both to ensure that the information is stored (and returned) in the correct format, but also for the purposes of collation and sorting. Each character set supports one or more collations, ...
https://dev.mysql.com/doc/internals/en/delete-row.html
If you keep a pointer to the last row or can access a primary key it will make doing the deletion quite a bit easier. Synopsis virtual int delete_row ( buf); const byte * buf ; Description This is the delete_row method. buf will contain a copy of ...
https://dev.mysql.com/doc/internals/en/end-markers-in-json-system-variable.html
If a JSON structure is large, it's difficult to pair its closing bracket with its opening bracket; to help the reader (but this is not JSON-compliant), setting @@end_markers_in_json=on repeats the structure's key (if it has one) near the closing ...
https://dev.mysql.com/doc/internals/en/err-instead-of-eof.html
1f 00 00 23 00 00 06 03 64 65 66 00 00 00 0d 70 ...#....def....p 6f 73 73 69 62 6c 65 5f 6b 65 79 73 00 0c 08 00 ossible_keys.... 00 10 00 00 fd 00 00 1f 00 00 19 00 00 07 03 64 ...............d 65 66 00 00 00 03 6b 65 79 00 0c 08 00 40 00 00 ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
SELECT fails after inserting 1000 rows into a MyISAM table (for example, with a duplicate-key violation), we have to write this statement to the binary log, because it truly modified the MyISAM table. Flags that indicate whether certain keywords are ... The following sections provide details about what appears in the fixed and variable parts of the event data for each event ...
https://dev.mysql.com/doc/internals/en/implementing-index-first-method.html
The [custom-engine.html#custom-engine-api-reference-index_first index_first()] method is used for index scanning: int ha_foo::index_first(byte * buf) The *buf parameter is populated with the row that corresponds to the first key value in the index.
https://dev.mysql.com/doc/internals/en/implementing-index-last-method.html
The [custom-engine.html#custom-engine-api-reference-index_last index_last()] method is used for reverse index scanning: int ha_foo::index_last(byte * buf) The *buf parameter is populated with the row that corresponds to the last key value in the ...
https://dev.mysql.com/doc/internals/en/implementing-index-next-method.html
The [custom-engine.html#custom-engine-api-reference-index_next index_next()] method is used for index scanning: int ha_foo::index_next(byte * buf) The *buf parameter is populated with the row that corresponds to the next matching key value ...