Search Results
https://dev.mysql.com/doc/heatwave-aws/en/database-vector-store.html
To generate embedding for a file stored in your Amazon S3 bucket, connect to your DB System, create a database, and use the heatwave_load() stored procedure routine to load the file. MySQL HeatWave GenAI In-database Vector Store 14.3 MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-prerequisites.html
Prerequisites 12.2 Prerequisites Here are some prerequisites for creating a high availability DB System. All default MySQL configurations that are compatible with high availability are indicated as so in the MySQL Configuration Details, If you want ...A high availability DB System requires a high availability compatible ...
https://dev.mysql.com/doc/connector-j/en/connector-j-opentelemetry.html
This simple demonstration contains a class OTelDemo, which creates a connection to the Sakila database and executes an SQL SELECT statement that returns five rows from the table film. This trace becomes the current context (parent) for any ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
Once a data file has been created, its size cannot be changed; however, you can add more data files to an NDB tablespace using additional ALTER TABLESPACE ... ADD DATAFILE is used with ENGINE = NDB, a data file is created on each Cluster data node, ...It can be used to add a new data file to, or to drop a data file from an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates the table definition in the global data dictionary. The setup for the source is: CREATE TABLE t1 (public_col_1, ..., public_col_N, secret_col_1, ..., secret_col_M) ENGINE=MyISAM; The setup for ...
https://dev.mysql.com/doc/refman/8.4/en/charset-column.html
CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET latin1 COLLATE latin1_bin; The character set and collation are specified for the column, so they are used. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET ... Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column ...
https://dev.mysql.com/doc/refman/8.4/en/charset-examples.html
Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE latin2_bin; Here we have a column with a latin1 character set and a latin1_german1_ci ... The ...
https://dev.mysql.com/doc/refman/8.4/en/csv-storage-engine.html
When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. If you examine the test.CSV file in the database directory created by executing the preceding statements, ... The CSV storage engine stores data in text files using comma-separated values ...