Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
Some external articles and tips that may be useful when using Access, ODBC and Connector/ODBC: Read How to Trap ODBC Login Error Messages in Access Optimizing Access ODBC Applications Optimizing for Client/Server Performance Tips for Converting ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchone.html
Syntax: row = cursor.fetchone() This method retrieves the next row of a query result set and returns a single sequence, or None if no more rows are available. By default, the returned tuple consists of data returned by the MySQL server, converted ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorbuffered.html
For queries executed using a buffered cursor, row-fetching methods such as fetchone() return rows from the set of buffered rows. MySQLCursorBuffered can be useful in situations where multiple queries, with small result sets, need to be combined or ...After executing a query, a MySQLCursorBuffered cursor fetches the entire result set from the server and buffers the ...
https://dev.mysql.com/doc/internals/en/binlog-formats.html
Queries can be logged in two ways: In statement format: the SQL query is written to the binlog in text. Status of this subsection: Complete but not reviewed 2009-10-21 The binlog is organized as a linear sequence of events. An SQL query that ...
https://dev.mysql.com/doc/internals/en/com-stmt-prepare.html
COM_STMT_PREPARE creates a prepared statement from the passed query string. The server returns a COM_STMT_PREPARE Response which contains a statement-id which is used to identify the prepared statement.
https://dev.mysql.com/doc/internals/en/full-text-search.html
MySQL uses Ranking with Vector Spaces for ordinary full-text queries. Rank, also known as relevance rank, also known as relevance measure, is a number that tells us how good a match is. Vector Space, which MySQL sometimes calls "natural language", ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
And now we're going to walk through something harder, namely the server. WARNING WARNING WARNING: code changes constantly, so names and parameters may have changed by the time you read this. Important files we'll be walking through: /sql/mysqld.cc ...
https://dev.mysql.com/doc/internals/en/transformations-all-any.html
ALL uses an inverted function, and all subqueries passed as arguments to Item_func_not_all (Item_func_not_all is a special NOT function used in optimization, see following). ALL/ANY/SOME use the same algorithm (and the same method of ...
https://dev.mysql.com/doc/internals/en/x-protocol-notices-notices.html
If a client maintains a cache of recent queries + resultsets it would improve the caching behavior if the client would be notified if a underlying table or schema was dropped, changed, and so on. Global Notices Global Notices are sent by the server ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords.html
This section contains information on the keywords and reserved words within the server when creating and submitting queries to the system. For more information on reserved words and their impact on your queries, see Keywords and Reserved Words, in ...The following table shows all keywords and reserved words available in MySQL ...