Search Results
https://dev.mysql.com/doc/heatwave-aws/en/database-vector-store.html
MySQL HeatWave GenAI In-database Vector Store 14.3 MySQL HeatWave GenAI In-database Vector Store The automated, in-database vector store enables customers to use MySQL HeatWave GenAI with their business documents without moving data to a separate ...The vector store can now be used with the ML_RAG and ML_RAG_TABLE routines; see MySQL HeatWave GenAI ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
Once you know how to enter SQL statements, you are ready to access a database. For example, a database like this could be used by a farmer to keep track of livestock, or by a veterinarian to keep track of patient records. Use the SHOW statement to ...Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-database-file-io.html
Table 5.2 Database File I/O By Host NameDescription Host The host from which the client connected. Database File I/O By Thread The Database File I/O By Thread dashboard summarizes I/O consumers to display time waiting for I/O, grouped by thread.
https://dev.mysql.com/doc/refman/8.4/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. The LIKE clause, if present, indicates which database names to match. You see only those databases for which you have some kind of ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You might have to run commands as the MySQL root user on the new machine until you have the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
(The ALTER ROUTINE privilege is required to drop the routine.) The server also automatically drops those privileges from the creator when the routine is dropped. If automatic_sp_privileges is 0, the server does not automatically add or drop these ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET ...If ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
DROP Enables use of statements that drop (remove) existing databases, tables, and views. This also means that database objects created by users with the SYSTEM_USER privilege cannot be modified or dropped by users without the privilege. DROP for the ...These privileges are global because they are not specific to a particular ... The ...