Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/8.4/en/static-format.html
NULL columns require additional space in the row to record whether their values are NULL. Each NULL column takes one bit extra, rounded up to the nearest byte. The expected row length in bytes for static-sized rows is calculated using the following ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
Use NULL to collect data for the default of 60 seconds. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
row *************************** Name: t1 Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2021-02-18 12:18:28 Update_time: ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-library-init.html
#include <mysql.h> #include <stdlib.h> int main(void) { if (mysql_library_init(0, NULL, NULL)) { fprintf(stderr, "could not initialize MySQL client library\n"); exit(1); } /* Use any MySQL API functions here */ mysql_library_end(); return ... int ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-native-function.html
This function should also set maybe_null = 0 if the main function cannot return a NULL value. The function can check whether any of the function arguments can return NULL by checking the arguments' maybe_null variable. If you want to return NULL ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-anomaly-detection-logs.html
This column labels identified anomalous logs with a value of 1, non-anomalous logs with 0, and unlabeled logs with NULL. You can set either embedding_model or keyword_model to NULL, but you cannot set both to NULL. Anomaly detection for logs allows ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-data-drift-detection.html
mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); Run ML_PREDICT_TABLE to generate a table of predictions. mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); Run ML_PREDICT_ROW to generate predictions for a defined number of rows. MySQL AI ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-load-model.html
The following example loads an AutoML model from the model catalog by using the session variable mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); Where: @census_model is the session variable that contains the model handle. NULL is specified in ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-export.html
ML_MODEL_EXPORT Overview After you run ML_MODEL_EXPORT, the output table has these columns and formats: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT DEFAULT NULL model_metadata: JSON See Model Metadata. ML_MODEL_EXPORT should work ... Use the ML_MODEL_EXPORT routine to export a model from the model catalog to a user defined ...