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. Others worry that AI could be used for
malicious ";

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", "LLM", "language", "Language"));

Replace the following:

For example:

mysql> SELECT sys.ML_GENERATE(@text,
JSON_OBJECT("task", "summarization", "model_id", "llama3.2-3b-instruct-v1", "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": "\nHere is a concise summary of the text:\n\nArtificial Intelligence (AI) has the potential
to revolutionize various aspects of life and work. AI systems can perform tasks that typically require
human intelligence, such as visual perception, speech recognition, and decision-making. Machine learning,
a subset of AI, enables computers to learn from data without explicit programming. AI is already being
applied in healthcare, finance, and transportation, with applications including personalized treatment
plans, fraud detection, and self-driving cars. However, there are concerns about the impact of AI on
society, including job displacement and potential misuse for malicious purposes.", "license": "Your
use of this llama model is subject to your Oracle agreements and this llama license agreement:
https://downloads.mysql.com/docs/LLAMA_32_3B_INSTRUCT-license.pdf"} |

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", "LLM", "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", "llama3.2-3b-instruct-v1", "language", "en"));

View the contents of the output table:

mysql> SELECT * FROM output_table\G
*************************** 1. row ***************************
    id: 1
Output: {"text": "\nHere is a concise summary:\n\nMySQL is an
open-source relational database management system (RDBMS) that
is widely used for its scalability, reliability, and security.
It uses a client-server architecture and supports various
operating systems. Key features include stored procedures for
efficient code reuse, support for multiple data types,
encryption for data protection, and the ability to handle large
amounts of data through horizontal or vertical scaling.", 
"error": null, 
"license": "Your use of this llama model is subject to
your Oracle agreements and this llama license agreement:
https://downloads.mysql.com/docs/LLAMA_32_3B_INSTRUCT-license.pdf"}
*************************** 2. row ***************************
    id: 2
Output: {"text": "\nHere is a concise summary:\n\nArtificial
Intelligence (AI) refers to the simulation of human
intelligence in machines. There are two types: narrow AI
(limited to specific tasks) and general AI (capable of
understanding any intellectual task). AI technologies include
machine learning, deep learning, natural language processing,
robotics, and expert systems. With numerous applications
across industries, AI has the potential to revolutionize
various aspects of life, but also raises concerns about
employment, privacy, and safety.", 
"error": null}
*************************** 3. row ***************************
    id: 3
Output: {"text": "\nHere is a concise summary:\n\nMachine
learning is a subset of AI that enables systems to improve
their performance over time by learning from data. It involves
developing algorithms and statistical models to make predictions
or decisions without explicit programming. There are three main
types: supervised, unsupervised, and reinforcement learning.
Supervised learning uses labeled data for prediction, while
unsupervised learning identifies patterns in unlabeled data.
Reinforcement learning involves an agent interacting with its
environment, receiving feedback to improve behavior through trial
and error.", 
"error": null}

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.