Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 8.4 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ... The MySQL ...
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/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/ndbapi/en/ndb-foreignkey.html
This section provides information about the ForeignKey class, which models a foreign key on an NDB table. ForeignKey Class Overview ForeignKey() ForeignKey::FkAction ForeignKey::getName() ForeignKey::getParentTable() ForeignKey::getChildTable() ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
The server executable determines its own full path name at startup and uses the parent of the directory in which it is located as the default basedir value. --check-table-functions=value Command-Line Format --check-table-functions=value Type ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
To generate AutoML queries, NL2ML leverages the databases, tables, and table columns in the DB System. This includes detailed instructions to do the following: Join your dataset's various tables into a single table. If table and column names are ...