To define your natural-language query, set the @query variable:

mysql> SET @query="QueryInNaturalLanguage";

Replace QueryInNaturalLanguage with a natural-language query of your choice. For example:

mysql> SET @query="Write an article on Artificial intelligence in 200 words.";

To generate text-based content, pass the query to the LLM using the ML_GENERATE routine with the task parameter set to generation:

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

Replace the following:

For example:

mysql> SELECT sys.ML_GENERATE(@query,
JSON_OBJECT("task", "generation", "model_id", "llama3.2-3b-instruct-v1", "language", "en"));

Text-based content that is generated by the LLM in response to your query is printed as output. It looks similar to the text output shown below:

| {"text": "\n**The Rise of Artificial Intelligence: Revolutionizing the Future**\n\nArtificial
intelligence (AI) has been a topic of interest for decades, and its impact is becoming increasingly
evident in various aspects of our lives. AI refers to the development of computer systems that can
perform tasks that typically require human intelligence, such as learning, problem-solving, and
decision-making.\n\nThe latest advancements in machine learning algorithms and natural language
processing have enabled AI systems to become more sophisticated and efficient. Applications of AI
are expanding rapidly across industries, including healthcare, finance, transportation, and education.
For instance, AI-powered chatbots are being used to provide customer support, while self-driving
cars are being tested on roads worldwide.\n\nThe benefits of AI are numerous. It can automate
repetitive tasks, improve accuracy, and enhance productivity. Moreover, AI has the potential to solve
complex problems that were previously unsolvable by humans. However, there are also concerns about job
displacement and bias in AI decision-making.\n\nAs AI continues to evolve, it is essential to address
these challenges and ensure that its benefits are shared equitably among all stakeholders. With
continued investment in research and development, AI has the potential to transform industries and
improve lives worldwide. The future of work will be shaped by AI, and it's crucial to prepare for
this", "license": "Your use of this Llama model is subject to the Llama 3.2 Community License Agreement
available at https://docs.oracle.com/cd/E17952_01/heatwave-9.4-license-com-en/"} |

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

mysql> CALL sys.ML_GENERATE_TABLE("InputDBName.InputTableName.InputColumn", "OutputDBName.OutputTableName.OutputColumn",
JSON_OBJECT("task", "generation", "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", "generation", "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": "\nMySQL is an open-source relational database
management system (RDBMS) that allows users to store, manage,
and retrieve data in a structured format. It supports various
features like SQL queries, indexing, transactions, and security,
making it a popular choice for web applications, enterprise
software, and mobile apps development.", 
"error": null,
"license": "Your use of this Llama model is subject to the
Llama 3.2 Community License Agreement available at
https://docs.oracle.com/cd/E17952_01/heatwave-9.4-license-com-en/"}
*************************** 2. row ***************************
    id: 2
Output: {"text": "\nArtificial Intelligence (AI) refers to the
development of computer systems that can perform tasks that
typically require human intelligence, such as learning,
problem-solving, and decision-making. AI uses algorithms and
data to mimic human thought processes, enabling machines to
analyze, reason, and interact with humans in increasingly
sophisticated ways.", 
"error": null}
*************************** 3. row ***************************
    id: 3
Output: {"text": "\nMachine Learning (ML) is a subset of
Artificial Intelligence that enables systems to automatically
improve performance on a task without being explicitly programmed. 
It involves training algorithms on data, allowing them to learn
patterns and make predictions or decisions based on new, unseen
data, without human intervention.", 
"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.