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/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/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/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 ...
https://dev.mysql.com/doc/internals/en/implementing-index-prev-method.html
The [custom-engine.html#custom-engine-api-reference-index_prev index_prev()] method is used for reverse index scanning: int ha_foo::index_prev(byte * buf) The *buf parameter is populated with the row that corresponds to the previous matching key ...
https://dev.mysql.com/doc/internals/en/implementing-info-method.html
Prior to commencing a table scan, the [custom-engine.html#custom-engine-api-reference-info info()] method is called to provide extra table information to the optimizer. The information required by the optimizer is not given through return values ...
https://dev.mysql.com/doc/internals/en/index-first.html
Synopsis virtual int index_first ( buf); byte * buf ; Description This is the index_first method.