Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
For MyISAM tables, a boolean search can be done in the absence of an index (albeit more slowly), in which case it is possible to name columns from multiple tables. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function ...
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 64MB. This section also covers the related Lost ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
WITH ROLLUP queries, to test whether NULL values in the result represent super-aggregate values, the GROUPING() function is available for use in the select list, HAVING clause, and ORDER BY clause. The GROUP BY clause permits a WITH ROLLUP modifier ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; innodb_monitor_reset: Resets counter values to zero. SET GLOBAL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-config.html
To exclude results from any host except one in particular, use the --host option: $> ./ndb_config --host=198.51.100.176 -f : -r '\n' -q id,type 3:ndbd 5:ndb_mgmd In this example, we also used the short form -q to determine the attributes to be ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-chat.html
The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available vector stores by default. If the routine cannot find a vector store, then it calls the ML_GENERATE routine and uses ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-rag.html
The ML_RAG routine performs retrieval-augmented generation (RAG) by: Taking a natural-language query. This routine aims to provide detailed, accurate, and contextually relevant answers by augmenting a generative model with information retrieved ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-nl-sql.html
You can use this routine for generating and running SQL queries only for databases and tables that you have access to. schemas: specifies the databases to consider for generating and running SQL queries. tables: specifies the tables to consider for ...The routine also runs the generated SQL statement and displays the result ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-mysqlcommand.html
The default CommandType type, Text, is used for executing queries and other SQL commands. The MySqlCommand class represents a SQL statement to execute against a MySQL database. Class methods enable you to perform the following database operations: ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-add-attribute.html
Syntax: cursor.add_attribute(name, value) Adds a new named query attribute to the list, as part of MySQL server's Query Attributes functionality. name: The name must be a string, but no other validation checks are made; attributes are sent as is to ...