Search Results
https://dev.mysql.com/doc/connectors/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/connector-net/en/connector-net-programming-stored-proc.html
The applications do not need to hardcode table and column names, complicated queries, and so on. When you extend and optimize the queries in a stored procedure, all the applications that call the procedure automatically receive the benefits. A ...
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-efcore.html
MySQLDbFunctionsExtensions Provides CLR methods that get translated to database functions when used in LINQ to Entities queries. Namespaces in this section: MySql.EntityFrameworkCore.DataAnnotations Namespace MySQL.EntityFrameworkCore.Diagnostics ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html
When a query is requested on a table within Access, ODBC is used to execute the queries on the MySQL database. Figure 6.16 Linking Microsoft Access Tables To MySQL Tables, Choosing Unique Record Identifier Once the process has been completed, you ...
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 ...