Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
If you choose not to Create an External Table Using Lakehouse Auto Parallel Load, you can create the table manually. Create External Table Manually Example To demonstrate how to create an external table manually, the following example specifies a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manaully and specifying the files to load into the table, you specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement to load the data from the files into the table. This topic contains the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-overview.html
This topic describes how to prepare the data to use for a classification machine learning model. The classification use-case is to approve or reject loan applications for clients based on their personal and socioeconomic status, assets, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for logs. To prepare the data for this use case, you set ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-prepare.html
This topic describes how to prepare the data to use for a regression machine learning model. The regression use-case is to predict house prices based on the size of the house, the address of the house, and the state the house is located in. To ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html
Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or source-source replication deployments. In-process transactions are not lost, and no application exceptions are ...
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-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) ...