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/connector-python/en/connector-python-api-mysqlcursorprepared.html
In MySQL, there are two ways to execute a prepared statement: Use the PREPARE and EXECUTE statements. To repeatedly execute the same statement with different data for different executions, this is more efficient than using PREPARE and EXECUTE. For ...
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/internals/en/a-mysql-client-logs-in.html
00 00 27 75 3e 6f 38 66 79 4e 00 ff f7 08 02 00 ..'u>o8fyN...... 00 00 00 00 00 00 00 00 00 00 00 00 00 57 4d 5d .............WM] 6a 7c 53 68 32 5c 59 2e 73 00 j|Sh2\Y.s. which responds with a handshake packet which contains the version, some flags ...
https://dev.mysql.com/doc/internals/en/avoid-too-dense-code.html
except you intend to check the parser or the performance of the reader of the code ;-). Unfortunate example: select 1+1,1-1,1+1*2,8/5,8%5,mod(8,5),mod(8,5)|0,-(1+1)*-2; Improved example: SELECT 1 + 1, 1 - 1, 1 + 1 * 2, 8 / 5, 8 % 5, MOD(8,5), ...
https://dev.mysql.com/doc/internals/en/caching.html
(Note that the some of the filenames contain an incorrect spelling of the word “cache.”) Key Cache A shared cache for all B-tree index blocks in the different NISAM files. Uses hashing and reverse linked lists for quick caching of the most ...
https://dev.mysql.com/doc/internals/en/character-set.html
MySQL has a very flexible character set support as documented in Character Sets, Collations, Unicode. Number Hex Character Set Name 8 0x08 latin1_swedish_ci 33 0x21 utf8_general_ci 63 0x3f binary Protocol::CharacterSet A character set is defined in ...
https://dev.mysql.com/doc/internals/en/dbug-sleep.html
In cases where the normal server code does not have a block point at the critical place, one can insert an artificial synchronization point. open_tables(...) DBUG_EXECUTE_IF("sleep_open_and_lock_after_open", { const char *old_proc_info= ...
https://dev.mysql.com/doc/internals/en/error-flags.html
The following flags can be examined or set to alter the behavior during error handling: thd->net.report_error thd->net.report_error is set in my_message_sql() if the error message was registered. thd->query_error Like net.report_error, but is ...
https://dev.mysql.com/doc/internals/en/error-messages-storage-engine.html
To add error messages for table handlers, the following example may be helpful. Purpose: Implement the handler::get_error_message function as ha_federated::get_error_message to return the handler-specific error message. When you have returned the ...