Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-have-result-set.html
Syntax: has_rows = ccnx.have_result_set After execution of the query() method, this property indicates whether the query returns rows.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchall.html
Syntax: rows = cursor.fetchall() The method fetches all (or all remaining) rows of a query result set and returns a list of tuples. If no more rows are available, it returns an empty list.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchmany.html
Syntax: rows = cursor.fetchmany(size=1) This method fetches the next set of rows of a query result and returns a list of tuples. If no more rows are available, it returns an empty list. The number of rows returned can be specified using the size ...
https://dev.mysql.com/doc/internals/en/com-stmt-prepare-response.html
17 00 00 02 03 64 65 66 00 00 00 01 3f 00 0c 3f .....def....?..? 00 00 00 00 00 fd 80 00 00 00 00|17 00 00 03 03 ................ 64 65 66 00 00 00 01 3f 00 0c 3f 00 00 00 00 00 def....?..?..... fd 80 00 00 00 00|05 00 00 04 fe 00 00 02 00|1a ...
https://dev.mysql.com/doc/internals/en/debug-sync-facility.html
MySQL supports a Debug Sync Facility, which - in spite of the "debug" in its name - is completely independent from the DBUG facility (except that it uses DBUG to trace its operation, if DBUG is also configured in the server). The documentation here ...
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/memory-allocation-mysql-server.html
The basic logic to use: All things that are used only for the duration of a query are allocated in THD::mem_root through sql_alloc() or thd->alloc() except: Things that may grow, like string buffers of type String. Large blocks of memory used in ...
https://dev.mysql.com/doc/internals/en/optimizer-determining-join-type.html
Notice that there are a few other (undocumented) join types too, for subqueries. When evaluating a conditional expression, MySQL decides what join type the expression has. (Again: despite the word “join”, this applies for all conditional ...
https://dev.mysql.com/doc/internals/en/optimizer-index-join-type.html
Consider this query: SELECT column1 FROM Table1; If column1 is indexed, then the optimizer may choose to retrieve the values from the index rather than from the table. An index which is used this way is called a covering index in most texts. For ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...