Search Results
https://dev.mysql.com/doc/refman/9.7/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. Specifying the CHARACTER ...These might be changes to a data type, to attributes associated with a data type, or to an index ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-session.html
Session has the methods listed here: createSchema(String name): Creates a database having the specified name, and returns the corresponding Schema object. For currency and other special numeric values, create an instance of NumberFormat having the ... The Session object is always available as the session property of the global ...
https://dev.mysql.com/doc/refman/9.7/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. It differs from DELETE in the following ways: Truncate operations drop and re-create the table, which is much ...To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting ...
https://dev.mysql.com/doc/refman/9.7/en/view-updatability.html
For information about generated columns, see Section 15.1.24.8, “CREATE TABLE and Generated Columns”. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, called the view ... Some ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-from-group-replication.html
If you have an existing deployment of Group Replication and you want to use it to create a cluster, pass the adoptFromGR option to the dba.createCluster() function. The created InnoDB Cluster matches whether the replication group is running as ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-classification-overview.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE classification_data; mysql> USE ... This topic ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-regression-prepare.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE regression_data; mysql> USE regression_data; ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-genai-summarize-content.html
One of the key features of MySQL ', 'is its support for stored procedures, which allow developers to create reusable blocks of ', 'code that can be executed multiple times. The goal of AI is to create systems that ', 'can function intelligently and ... 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/relnotes/mysql-shell/9.7/en/news-9-7-0.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. reset_recovery_accounts_password() enables you to reset, or recreate, the credentials for the internal recovery and replication accounts and is now supported for ...
https://dev.mysql.com/doc/connectors/en/connector-net-connections-pooling.html
See Section 4.4.1, “Creating a Connector/NET Connection String” for further information. Subsequently, if a new MySqlConnection object is opened, it is created from the connection pool, rather than creating a new native connection. Do not create ... The MySQL Connector/NET supports connection pooling for better performance and scalability with database-intensive ...