Search Results
https://dev.mysql.com/doc/refman/9.7/en/except.html
As with UNION and INTERSECT, either query block can make use of any of SELECT, TABLE, or VALUES. query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlimport.html
Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ...] For each text file named on the command line, mysqlimport strips any extension from the file name and uses the result to determine the name of the table into which ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The column_statistics table has these characteristics: The table contains statistics for ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-consumer-filtering.html
For example, if you do not care about historical event information, disable the history consumers: UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%history%'; The consumer settings in the setup_consumers table form a ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-row-searches.html
When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching rows. The algorithm used to carry out this process uses one of the table's indexes to carry out the search ...Any index where the before-image of the row event does not contain all the columns of the ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-convenience-methods.html
The GenAI API provides the convenience methods described in this section under the ml namespace. These methods act as wrappers for the LLM methods; rather than being invoked as LLM instance methods, they take the model ID as one of the options ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/9.7/en/uninstall-plugin.html
It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. plugin_name must be the name of some plugin that is listed in the mysql.plugin table. The server executes the ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-genai-summarize-content.html
For Running Batch Queries, add the natural-language queries to a column in a new or existing table. It can scale horizontally by adding more servers to the cluster, or ', 'vertically by upgrading the hardware.' ) ); mysql> INSERT INTO input_table ...
https://dev.mysql.com/doc/internals/en/implementing-rnd-next-method.html
After the table is initialized, the MySQL server will call the handler's [custom-engine.html#custom-engine-api-reference-rnd_next rnd_next()] method once for every row to be scanned until the server's search condition is satisfied or an end of file ...The rnd_next() method takes a single byte array parameter named ...