Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
Loadable Function Calling Sequences for Simple Functions This section describes the different interface functions that you must define to create a simple loadable function. Loadable Function Calling Sequences for Aggregate Functions This section ...
https://dev.mysql.com/doc/internals/en/perfect-cleanup.html
Do not forget to remove all users you created and all permissions you granted. Cleaning up becomes much more comfortable and less error prone if you create your "own" database and create all tables there. Close all connections which you have ...At ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbinterpretedcode.html
Description NdbInterpretedCode represents an interpreted program for use in operations created using NdbRecord, or with scans created using the old API. To create an NdbInterpretedCode object, invoke the constructor, optionally supplying a table for ... This section provides information about the NdbInterpretedCode class, which can be used to prepare and execute an NDB API interpreted ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
A second call with the same argument returns the previously created handle. Once the read operation has been executed, an NdbLockHandle can be used to create a new unlock operation (with NdbTransaction::unlock()). (Use data, possibly making calls to ...Beginning with NDB 8.0.30, NdbOperation supports an interpreted code API similar to that implemented by ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
That is, it creates a machine learning model by analyzing a labeled dataset to learn patterns that enable it to predict labels based on the features of the dataset. The specific algorithm used depends on the characteristics of the data being ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
MySQL also supports setting the histogram of a single column to a user-defined JSON value. When sampling user data as part of building a histogram, not all values are read; this may lead to missing some values considered important. The sampling-rate ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
To search the title or body separately, you would create separate FULLTEXT indexes for each column. Alternatively, you can create FULLTEXT indexes using the ngram parser plugin (for Chinese, Japanese, or Korean) or the MeCab parser plugin (for ...