Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
Select the Change BIGINT columns to INT option in the connection dialog in ODBC DSN Administrator. You can fix this by selecting "Query|SQLSpecific|Pass-Through" from the Access menu. To deal with this, select the following options: Return Matching ... To improve the integration between Microsoft Access and MySQL through Connector/ODBC: For all versions of Access, enable the Connector/ODBC Return matching rows ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-with-rows.html
Syntax: boolean = cursor.with_rows This read-only property returns True or False to indicate whether the most recently executed operation could have produced rows. The with_rows property is useful when it is necessary to determine whether a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating asynchronous MySQL interactions with an application. Functions included in the asyncio API must be used to ...
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
A connection with the MySQL server can be established using either the mysql.connector.connect() function or the mysql.connector.MySQLConnection() class: cnx = mysql.connector.connect(user='joe', database='test') cnx = MySQLConnection(user='joe', ...
https://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/internals/en/full-text-search.html
And R is the floating-point number that you see if you say: SELECT MATCH(...) AGAINST (...) FROM t. MySQL uses Ranking with Vector Spaces for ordinary full-text queries. Rank, also known as relevance rank, also known as relevance measure, is a ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
If the last statement is a SELECT, the affected-rows count is 0. 01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ..............1. see the EOF_Packet: 05 00 00 03 fe 00 00 0a 00 with ...
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. For this query: SELECT column1, column2 FROM Table1; the optimizer will use join ...An index which is used this way is called a covering index in most ...
https://dev.mysql.com/doc/internals/en/optimizer-index-merge-join-type.html
for query: SELECT * FROM t WHERE (goodkey1=c1 OR goodkey1=c2) AND badkey=c3 scan on badkey will be chosen even if Index Merge on (goodkey1, goodkey) would be faster. 7.2.2.5.1 Overview Index Merge is used when table condition can be converted to ...
https://dev.mysql.com/doc/internals/en/transactions-notes-on-ddl-and-normal-transaction.html
DDL statements and operations with nontransactional engines do not "register" in thd->transaction lists, and thus do not modify the transaction state. Besides, each DDL statement in MySQL begins with an implicit normal transaction commit (a call to ...