Search Results
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/srjsapi-sqlresult.html
getAutoIncrementValue(): Retrieves the autogenerated ID used for the most recent insert operation. Calling this method is equivalent to executing LAST_INSERT_ID() in the mysql client. An SqlResult is produced whenever a query is executed using ...
https://dev.mysql.com/doc/refman/9.7/en/statement-caching.html
Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do SELECT statements. For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal ...
https://dev.mysql.com/doc/refman/9.7/en/stored-objects.html
A trigger is activated when a particular event occurs for the table, such as an insert or update. This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. Stored objects ...
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/subqueries.html
A subquery's outer statement can be any one of: SELECT, INSERT, UPDATE, DELETE, SET, or DO. All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a ...
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-revoke-schema-privileges-from-all-accounts-except.html
Revoke specified privileges for all users except those specified with the exclude_users argument. Parameters in_schema_name: (CHAR(255)) Schema name on which the privileges are revoked.
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.