Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
You can set DATE, TIME, DATETIME, and TIMESTAMP as optional column-level parameters. EXTERNAL_FORMAT {'date_format' | 'time_format' | 'timestamp_format'} The following example sets the date_format, time_format, and timestamp_format at the column ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location VARCHAR(100), purchase_amount DECIMAL(10, 2), purchase_time DATETIME, target INT ); Insert the sample data to train ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location VARCHAR(100), purchase_amount DECIMAL(10, 2), purchase_time DATETIME, target INT ); Insert the sample data to train ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Strict mode produces an error for attempts to create a key that exceeds the maximum key length. TIME_TRUNCATE_FRACTIONAL Control whether rounding or truncation occurs when inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-21.html
(Bug #29802379, Bug #95382) The microseconds value in the return results was set to zero consistently when SqlCommand.Prepare() was called for a SELECT statement with a TIME(n) column. (Bug #31237338, Bug #99371) An error was generated when the ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-cluster-log.html
A severity level is stored at position ndb_mgm_clusterlog_level; for example the error level is stored at position NDB_MGM_EVENT_SEVERITY_ERROR. Return value The number of returned severities, or -1 in the event of an error. Return value This ...
https://dev.mysql.com/doc/internals/en/innodb-page-header.html
The PAGE_FREE pointer in the page header points to the first record in the list. The "next" pointer in the record header (specifically, in the record's Extra Bytes) points to the next record in the list. PAGE_DIRECTION and PAGE_N_DIRECTION: It's ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Some statements require a lot of execution time on the source, but result in just a few rows being modified. It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer ...The logging format also can be switched at runtime, although note that there are a number of situations in which you cannot do this, as discussed later in this ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET. 5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-csharp.html
{ for (int i=0; i < MyOdbcException.Errors.Count; i++) { Console.Write("ERROR #" + i + "\n" + "Message: " + MyOdbcException.Errors[i].Message + "\n" + "Native: " + MyOdbcException.Errors[i].NativeError.ToString() + "\n" + "Source: " + ... The ...