Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/fetching-all-data-items-at-once.html
myResult = myTable.select(['name', 'age']) \ .where('name like :name').bind('name','L%') \ .execute() myRows = myResult.fetch_all() for row in myRows: print("%s is %s years old." % (row.name, row.age)) When mixing fetchOne() and fetchAll() to read ... In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume data items one by one, X DevAPI also provides a pattern using fetchAll(), which passes all data items of a data set as a list to the ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
The second OVER clause partitions rows by country, producing a sum per partition (per country). Query result rows are determined from the FROM clause, after WHERE, GROUP BY, and HAVING processing, and windowing execution occurs before ORDER BY, ...
https://dev.mysql.com/doc/internals/en/traceable-queries.html
If one of those statements is prepared and executed in separate steps, preparation and execution are separately traced. They are: SELECT; INSERT or REPLACE (with VALUES or SELECT); UPDATE/DELETE and their multi-table variants; all the previous ones ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-byo-embedding-tables.html
For example: mysql> ALTER TABLE demo_minilm_table SECONDARY_LOAD; This accelerates processing of vector distance function used to compare vector embeddings and generate relevant output later in this section. For example: mysql> ALTER TABLE ... GenAI ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-rag.html
For example: mysql> ALTER TABLE demo_db.demo_embeddings SECONDARY_LOAD; This accelerates processing of vector distance function used to compare vector embeddings and generate relevant output later in this section. For example: mysql> ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
As you can see from the result when the SELECT is run a second time, there remains a row in the table matching the WHERE condition, but residing in a different partition (p2). Each name in this list must be the name of an existing partition or ...
https://dev.mysql.com/doc/internals/en/mysql-server.html
dispatch_command Mysql-5.5 sql/sql_parse.cc:869 mysql_binlog_send Mysql-5.5 sql/sql_repl.cc:436 Mysql-5.6 sql/rpl_master.cc mysql_stmt_get_longdata Mysql-5.5 sql/sql_prepare.cc:2802 mysqld_stmt_prepare Mysql-5.5 sql/sql_prepare.cc:2165 ...Mysql-5.5 ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
If not specified, this argument defaults to its maximum value of 232 − 1. Option Value Meaning 1 Reject the document and produce an error. If srid refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
WAIT_FOR_EXECUTED_GTID_SET(): Waits until all transactions in a given GTID set have been executed. To perform the same check with GTID_SUBTRACT(), execute the following statement on the replica: SELECT GTID_SUBTRACT(source_gtid_executed, ... This ...