Search Results
https://dev.mysql.com/doc/refman/8.4/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
Initially, mysql executes statements in the input because specifying a database db_name on the command line is equivalent to inserting USE db_name at the beginning of the input. The INSERT and CREATE TABLE statements are executed because the default ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
This is where the privilege columns in the grant tables come into play. A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
MySQL permits a subquery to refer to a stored function that has data-modifying side effects such as inserting rows into a table. FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table ... In general, you cannot modify a table and select from the same table in a ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (The example shown earlier illustrates how this can occur.) The query ...(This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using the GenAI feature of MySQL AI: Before You Begin Generating Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-summarize-content.html
It can scale horizontally by adding more servers to the cluster, or ', 'vertically by upgrading the hardware.' ) ); mysql> INSERT INTO input_table (Input) VALUES( CONCAT( 'Artificial Intelligence or AI refers to the simulation of human intelligence ... The following sections in this topic describe how to summarize exiting content using the GenAI: Before You Begin Summarizing Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-sql-command.html
The results are usually returned into a MySqlDataReader object, and then processed. This is because ExecuteNonQuery is only used for inserting, updating and deleting data. When a connection has been established with the MySQL database, the next ...