Search Results
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-full-text-plugins.html
The following procedure describes how the plugin library is created: To write a full-text parser plugin, include the following header file in the plugin source file. This is the value that identifies the plugin as being legal for use in a WITH ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
One way to make collisions detectable is to make the hash column a primary key. These functions support the use of a key derivation function (KDF) to create a cryptographically strong secret key from the information passed in key_str. When you use a ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
mysql> SELECT COLUMN_NAME, EXTRA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 't1' AND EXTRA LIKE '%NOT SECONDARY%'; +-------------+---------------+ | COLUMN_NAME | EXTRA | +-------------+---------------+ | O_COMMENT | NOT SECONDARY | ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-storage-engines.html
The disabled_storage_engines configuration option defines which storage engines cannot be used to create tables or tablespaces. MySQL Enterprise Backup does a hot backup of all tables that use the InnoDB storage engine. For tables using MyISAM or ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). In addition, the cleanup of old events has been improved, which improves the cleanup of failed ...ndbinfo Information Database: Added a type column to the transporter_details table in the ndbinfo information ... MySQL NDB Cluster 8.4.1 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including features in ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete ...rs.Open "SELECT * FROM my_ado", conn Debug.Print rs.RecordCount rs.MoveFirst Debug.Print String(50, "-") & "Updated my_ado Result Set " & String(50, "-") For Each fld In rs.Fields Debug.Print fld.Name, Next Debug.Print Do Until rs.EOF For Each fld In rs.Fields Debug.Print fld.Value, Next rs.MoveNext Debug.Print Loop rs.Close conn.Close End ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes.html
This program illustrates how to use secondary indexes in the NDB API. The source code for this example may be found in the NDB Cluster source tree, in storage/ndb/ndbapi-examples/ndbapi_simple_index/main.cpp.
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean queries. The minimum and maximum word length full-text parameters apply to FULLTEXT indexes created using the built-in FULLTEXT parser and MeCab ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. The server also sends a CREATE TABLE statement for the table to mysqldump, which ...The output can be saved in a file and reloaded later using mysql to recreate the dumped ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud ...