To define the text that you want to summarize, set the @text variable:

mysql> SET @text="TextToSummarize";

Replace TextToSummarize with the text that you want to summarize.

For example:

mysql> SET @text="Artificial Intelligence (AI) is a rapidly growing field that has the potential
to revolutionize how we live and work. AI refers to the development of computer systems
that can perform tasks that typically require human intelligence, such as visual perception,
speech recognition, decision-making, and language translation. One of the most significant
developments in AI in recent years has been the rise of machine learning, a subset of AI that
allows computers to learn from data without being explicitly programmed. Machine learning
algorithms can analyze vast amounts of data and identify patterns, making them increasingly
accurate at predicting outcomes and making decisions. AI is already being used in a variety
of industries, including healthcare, finance, and transportation. In healthcare, AI is being
used to develop personalized treatment plans for patients based on their medical history and
genetic makeup. In finance, AI is being used to detect fraud and make investment
recommendations In transportation, AI is being used to develop self-driving cars and improve
traffic flow. Despite the many benefits of AI, there are also concerns about its potential impact
on society. Some worry that AI could lead to job displacement, as machines become more capable
of performing tasks traditionally done by humans.";

To generate the text summary, pass the original text to the LLM using the ML_GENERATE routine, with the task parameter set to summarization:

mysql> SELECT sys.ML_GENERATE(@query,
JSON_OBJECT("task", "summarization", "model_id", "ModelID", "language", "Language"));

Replace the following:

For example:

mysql> SELECT sys.ML_GENERATE(@text,
JSON_OBJECT("task", "summarization", "model_id", "mistral-7b-instruct-v3", "language", "en"));

A text summary generated by the LLM in response to your query is printed as output. It looks similar to the text output shown below:

| {"text": " Artificial Intelligence (AI) is a growing field that uses computer 
systems to perform tasks requiring human intelligence, such as visual perception 
and decision-making. Machine learning, a subset of AI, allows computers to learn 
from data without being explicitly programmed. AI is already being used in various 
industries, including healthcare, finance, and transportation. However, there are 
concerns about job displacement due to its increasing capabilities."} |

In the ML_GENERATE_TABLE routine, specify the table columns containing the input queries and for storing the generated text summaries:

mysql> CALL sys.ML_GENERATE_TABLE("InputDBName.InputTableName.InputColumn", "OutputDBName.OutputTableName.OutputColumn",
JSON_OBJECT("task", "summarization", "model_id", "ModelID", "language", "Language"));

Replace the following:

For example:

mysql> CALL sys.ML_GENERATE_TABLE("demo_db.input_table.Input", "demo_db.output_table.Output",
JSON_OBJECT("task", "summarization", "model_id", "mistral-7b-instruct-v3", "language", "en"));

View the contents of the output table:

mysql> SELECT * FROM output_table\G
*************************** 1. row ***************************
    id: 1
Output: {"text": " MySQL is an open-source RDBMS based on the 
SQL standard, designed for scalability, reliability, and 
security. It uses a client-server architecture, supports stored 
procedures, a wide range of data types, encryption, and can 
handle large amounts of data by scaling horizontally or 
vertically.", "error": null}
*************************** 2. row ***************************
    id: 2
Output: {"text": " Artificial Intelligence (AI) is the 
simulation of human intelligence in machines, designed to 
think and act like humans. It includes two types: narrow AI 
for specific tasks and general AI with broader capabilities. 
Techniques include machine learning, deep learning, natural 
language processing, robotics, and expert systems. AI has 
various applications across industries but raises concerns 
about employment, privacy, and safety.", "error": null}
*************************** 3. row ***************************
    id: 3
Output: {"text": " Machine learning is a subset of artificial 
intelligence that involves training machines to make predictions 
or decisions without being explicitly programmed. It includes 
supervised, unsupervised, and reinforcement learning. Supervised 
learning uses labeled data, while unsupervised learning uses 
unlabeled data. Reinforcement learning involves an agent 
interacting with an environment and learning through trial 
and error.", "error": null}

As of MySQL 9.3.0, the output table generated using the ML_GENERATE_TABLE routine contains an additional details for error reporting. In case the routine fails to generate output for specific rows, details of the errors encountered and default values used are added for the row in the output column.