Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-classifier.html
(Inserts into outputTable; see ML_PREDICT_ROW.) Version 2 Predicts a label for a single sample of data, and returns it. Classifier Constructor Classifier.train() Classifier.fit() Classifier.predict() Classifier.predictProba() Classifier.score() ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-explainer.html
(Inserts into a table.) Version 2 Explains a sample containing training data, which must contain members used in training; extra members are ignored. This class is an abstraction of the AutoML explainer model as described in Generate Model ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-forecaster.html
(Inserts into a target table.) Version 2 Predicts a label for a single sample of data, and returns it. Forecaster Constructor Forecaster.train() Forecaster.fit() Forecaster.predict() Forecaster.score() Forecaster.unload() This class encapsulates ...
https://dev.mysql.com/doc/refman/9.7/en/string-comparison-functions.html
For example, consider the following table and data: CREATE TABLE foo (bar VARCHAR(10)); INSERT INTO foo VALUES (NULL), (NULL); The query SELECT COUNT(*) FROM foo WHERE bar LIKE '%baz%'; returns 0. Table 14.13 String Comparison Functions and ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-reset-to-default.html
row *************************** status: Resetting: setup_actors INSERT IGNORE INTO performance_schema.setup_actors VALUES ('%', '%', '%') ... Parameters in_verbose BOOLEAN: Whether to display information about each setup stage during procedure ...
https://dev.mysql.com/doc/refman/9.7/en/sys-sys-config.html
To enable debug output without having to set that variable in individual sessions, add the option to the table: mysql> INSERT INTO sys.sys_config (variable, value) VALUES('debug', 'ON'); To change the debug setting in the table, do two things. This ...
https://dev.mysql.com/doc/refman/9.7/en/time.html
In particular, any fractional part in a value inserted into a TIME column is stored rather than discarded. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/view-restrictions.html
Dump files created with mysqldump cannot be loaded into servers that enforce the column-length restriction. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible ...