MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 351 to 360 of 363 total results

https://dev.mysql.com/doc/refman/9.7/en/srjs-libraries.html

This section provides information about and examples of use of JavaScript libraries in JavaScript stored programs as supported by the Multilingual Engine (MLE) in MySQL Enterprise Edition. First we create a database jslib, and make it the current ...

27.3.10.1 AnomalyDetector Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-anomalydetector.html

AnomalyDetector Constructor AnomalyDetector.train() AnomalyDetector.fit() AnomalyDetector.predict() AnomalyDetector.score() AnomalyDetector.unload() This class encapsulates the anomaly detection task as described in Detect Anomalies.

27.3.10.2 Classifier Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-classifier.html

Classifier Constructor Classifier.train() Classifier.fit() Classifier.predict() Classifier.predictProba() Classifier.score() Classifier.explain() Classifier.getExplainer() Classifier.unload() This class encapsulates the classification task as ...

27.3.10.4 Forecaster Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-forecaster.html

Forecaster Constructor Forecaster.train() Forecaster.fit() Forecaster.predict() Forecaster.score() Forecaster.unload() This class encapsulates the forecasting task as described in Generate Forecasts. Forecaster supports methods for loading, ...

27.3.6.12 MySQL Functions

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-mysql.html

The following SQL built-in functions can be called directly from the mysql namespace. These are described in the following list, along with their analogous SQL functions: rand() (MySQL RAND()): Returns a random floating-point value v in the range 0 ...

27.3.10.6 Recommender Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-recommender.html

Recommender Constructor Recommender.train() Recommender.fit() Recommender.predictRatings() Recommender.predictItems() Recommender.predictUsers() Recommender.predictSimilarItems() Recommender.predictSimilarUsers() Recommender.score() ...

27.3.10.7 Regressor Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-regressor.html

Regressor Constructor Regressor.train() Regressor.fit() Regressor.predict() Regressor.score() Regressor.explain() Regressor.getExplainer() Regressor.unload() This class is similar to Classifier and Forecaster in that it represents an AutoML ...

10.2.2.2 Optimizing Subqueries with Materialization

https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html

The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...

10.4.3.1 How MySQL Opens and Closes Tables

https://dev.mysql.com/doc/refman/9.7/en/table-cache.html

When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.

27.4.1 Trigger Syntax and Examples

https://dev.mysql.com/doc/refman/9.7/en/trigger-syntax.html

To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.26, “CREATE TRIGGER Statement”, and Section 15.1.39, “DROP TRIGGER Statement”. Here is a simple example that associates a ...

Displaying 351 to 360 of 363 total results