Search Results
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-4-0.html
(Bug #37285902) CREATE TABLE with a generated column expression, such as a CHECK constraint, which referenced a non-ASCII identifier caused a syntax error if the current client character set was not compatible with UTF-8 (for example, GBK). (Bug ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/refman/9.7/en/log-destinations.html
Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system database. Log Control at Server Startup Log Control at Runtime Log Table Benefits and Characteristics Log Control at Server Startup The ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-recommender.html
SignatureRecommender.train( Table trainData, String users, String items, String ratings ) Arguments trainData (Table): A Table containing a training dataset. The maximum size of the table must not exceed 10 GB space, 100 million rows, or 1017 ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
When working with InnoDB tables, consider also the innodb_strict_mode system variable. Setting the SQL Mode The default SQL mode in MySQL 9.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ... The MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
Tables in the firewall database provide backing storage of firewall data for persistence of profiles across server restarts. Stored procedures perform tasks such as registering firewall profiles, establishing their operational modes, and managing ...
https://dev.mysql.com/doc/ndbapi/en/ndb-event.html
Event Class Overview Event::addEventColumn() Event::addEventColumns() Event::addTableEvent() Event Constructor Event::EventDurability Event::EventReport Event::getDurability() Event::getEventColumn() Event::getName() Event::getNoOfEventColumns() ...
https://dev.mysql.com/doc/refman/9.7/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... A table reference (when it refers ...index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb.html
Methods The following table lists the public methods of this class and the purpose or use of each method: Table 2.26 Ndb class methods and descriptions Name Description Ndb() Class constructor; represents a connection to an NDB Cluster. (See Section ... This section provides information about the Ndb class, which models the NDB kernel; it is the primary class of the NDB ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-data-encryption.html
InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo logs. You can set an encryption default for schemas and general tablespaces; this permits DBAs to control ...InnoDB data-at-rest encryption features and capabilities are described under the following topics in this ...