Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
After this, all tables created in the database mydb are created in D:\data\mydb. After this, all tables created in the database mydb are created in D:\data\mydb. To do this, create a symbolic link in the MySQL data directory that points to ... On ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
This option modifies the ENGINE= clause of CREATE TABLE statements to specify INNODB for tables that do not already use the InnoDB storage engine. This modifier removes the TABLESPACE clause from GRANT statements, so all tables are created in their ...loadDump command only allows import of dumps created with the ocimds option ... MySQL Server Compatibility 7.1.2 MySQL Server Compatibility MySQL HeatWave on AWS has several ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-tablemapping.html
There is no public constructor for this object; you can create a FieldMapping using TableMapping.mapField(), or you can use FieldMapping literals can be used directly in the TableMapping constructor. TableMapping mapField(String fieldName, [String ... A TableMapping describes the mapping of a domain object in the application to a table stored in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog.html
The MODEL_CATALOG table is created in a schema named ML_SCHEMA_user_name, where the user_name is the name of the owning user. When a user creates a model, the ML_TRAIN routine creates the model catalog schema and table if they do not exist. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns. A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER ...This rules out, for example, a table column because that can differ for each ... MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
See Section 15.1.20, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-faq.html
Set the configuration option innodb_file_per_table=1 before creating your biggest or most active InnoDB tables. This file represents the InnoDB system tablespace, which grows but never shrinks as a database server operates, and is included in every ... This section lists some common questions about MySQL Enterprise Backup, with answers and pointers to further ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-json.html
You can import the JSON documents to an existing table or collection or to a new one created for the import. If the target table or collection does not exist in the specified database, it is automatically created by the utility, using a default ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-model-catalog.html
The MODEL_CATALOG table is created in a schema named ML_SCHEMA_user_name, where the user_name is the name of the owning user. When a user creates a model, the ML_TRAIN routine creates the model catalog schema and table if they do not exist. AutoML ...A model catalog is accessible only to the owning user unless the user grants privileges on the model catalog to another ...