Search Results
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/connector-python/en/connector-python-example-ddl.html
All DDL (Data Definition Language) statements are executed using a handle structure known as a cursor. The following examples show how to create the tables of the Employee Sample Database. In a MySQL server, tables are very long-lived objects, and ...
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/creating-handlerton.html
The handlerton (short for handler singleton) defines the storage engine and contains method pointers to those methods that apply to the storage engine as a whole, as opposed to methods that work on a per-table basis. Some examples of such methods ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
When a new connection is established, thd->transaction members are initialized to an empty state. If a statement uses any tables, all affected engines are registered in the statement engine list. In non-autocommit mode, the same engines are ...