Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-query-iter.html
Syntax: cnx.cmd_query_iter(statement) Similar to the cmd_query() method, but returns a generator object to iterate through results. Use cmd_query_iter() when sending multiple statements, and separate the statements with semicolons. The following ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-set-charset-collation.html
Syntax: cnx.set_charset_collation(charset=None, collation=None) This method sets the character set and collation to be used for the current connection. The charset argument can be either the name of a character set, or the numerical equivalent as ...
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/interface-to-third-party-tools.html
Previously, third-party tools that need to determine the MySQL version from the MySQL source read the configure.in file in the top-level source directory. For example, the AC_INIT line for MySQL 5.5.7-rc looked like this: AC_INIT([MySQL Server], ...
https://dev.mysql.com/doc/internals/en/memory-allocation-library-or-storage-engine.html
For the simple case, use the functions in mysys/my_malloc.c: void *my_malloc(size_t size, myf my_flags); void *my_memdup(const void *from, size_t length, myf my_flags); char *my_strdup(const char *from, myf my_flags); char *my_strndup(const char ...
https://dev.mysql.com/doc/internals/en/myisampack-tricks.html
As already mentioned, myisampack uses some tricks to decrease the amount of data to be encoded. These cope with leading and trailing spaces or zeros or with all blank or NULL fields. They do not materialize in the compressed data files other than ...
https://dev.mysql.com/doc/internals/en/non-client-plugin-auth-clients.html
The only situation where server will request authentication method change from a client which does not set CLIENT_PLUGIN_AUTH flag is when the following conditions hold: the client connects to an account which uses Old Password Authentication. the ...
https://dev.mysql.com/doc/internals/en/preparing-for-index-use.html
The [custom-engine.html#custom-engine-api-reference-index_init index_init()] method is called before an index is used to allow the storage engine to perform any necessary preparation or optimization: int ha_foo::index_init(uint keynr, bool sorted) ...
https://dev.mysql.com/doc/internals/en/select-select-engine.html
subselect_single_select_engine: constructor allocate JOIN and store pointers on SELECT_LEX and JOIN. fix_length_and_dec() prepare cache and receive type and parameters of returning items (called only by Item_singlerow_subselect). If this is the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...