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 ...
https://dev.mysql.com/doc/connector-j/en/connector-j-fractional-seconds.html
However, when Connector/J inserted a java.sql.TIME into the server as a MySQL TIME value, the fractional seconds were always truncated. While a java.sql.TIME instance, according to the JDBC specification, is not supposed to contain fractional ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. The MySQL server reads the contents of ... MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
If instead you modify the contents of those tables directly using statements such as INSERT, UPDATE, and DELETE, the changes do not affect filtering immediately. Table 8.44 Write-Strategy Effect on the Direct Write Count Write Strategy Description ...Unless those objects are installed, the audit_log plugin operates in (deprecated) legacy ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
With binary logging enabled, the server writes each data change into a file while it updates data. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a ...
https://dev.mysql.com/doc/refman/8.4/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...
https://dev.mysql.com/doc/refman/8.4/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 12.12, “Setting the Error Message Language”. For ...
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
INSERT INTO t1 (latin1_column) SELECT USER(); This works because the contents of USER() are automatically converted to latin1 before the assignment. Metadata is “the data about the data.” Anything that describes the database—as opposed to ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
Indexes are good for retrieval, but slow down insert and update operations. Joins In some circumstances, it can be beneficial to split into two a table that is scanned very often. Design your tables to minimize their space on the disk. This can ...