Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/9.7/en/show-library-status.html
SHOW LIBRARY STATUS [LIKE 'pattern' | WHERE expr] This statement provides information about one or more JavaScript libraries. Like SHOW FUNCTION STATUS and SHOW PROCEDURE STATUS, it supports LIKE and WHERE clauses for filtering the output. See ...
https://dev.mysql.com/doc/refman/9.7/en/slow-query-log.html
Passwords in statements written to the slow query log are rewritten by the server not to occur literally in plain text. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least ...
https://dev.mysql.com/doc/refman/9.7/en/source-configuration-options.html
The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For information about options supported by CMake, run either of these commands in ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. mysql> SET @gh = ST_GeoHash(45,-20,10); mysql> SELECT ST_AsText(ST_PointFromGeoHash(@gh,0)); +---------------------------------------+ | ...Geohash values are strings that contain only characters chosen from ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-data-metadata.html
This includes the names of the columns in the result set. If the result set is not empty, the contents of each row are printed in the order obtained; otherwise, the function gets the number of rows affected by the statement and the value of the last ...
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 ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-management.html
The text of the routine body is always treated as utf8mb4 regardless of the character set actually used. The syntax of the routine body is checked at creation time; any errors cause the CREATE statement to be rejected, and the stored program not to ...
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.
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 ...