Search Results
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
The rows in these tables for a given account indicate the account privileges that apply on a global basis no matter what the default database is. For example, if the user table grants you the DELETE privilege, you can delete rows from any table in ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-function-reference.html
The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
Statement processing following mysql_stmt_execute() depends on the type of statement: For an UPDATE, DELETE, or INSERT, the number of changed, deleted, or inserted rows can be found by calling mysql_stmt_affected_rows(). Example The following ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-predict-table.html
If ML_PREDICT_TABLE takes a long time to complete, manually limit input tables to a maximum of 1,000 rows. Set a positive integer between 1 and the number of rows in the table. threshold: The threshold you set on anomaly detection models determines ... ML_PREDICT_TABLE generates predictions for an entire table of unlabeled ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-score.html
Set a positive integer between 1 and the number of rows in the table. threshold: The threshold you set on anomaly detection models determines which rows in the output table are labeled as anomalies with an anomaly score of 1, or normal with an ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-fetchone.html
Syntax: row = cursor.fetchone() This method retrieves the next row of a query result set and returns a single sequence, or None if no more rows are available. By default, the returned tuple consists of data returned by the MySQL server, converted ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchone.html
Syntax: row = cursor.fetchone() This method retrieves the next row of a query result set and returns a single sequence, or None if no more rows are available. By default, the returned tuple consists of data returned by the MySQL server, converted ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-query-analyzer-ref.html
Each row within the table provides the statistical information for one normalized query. Selecting a query loads additional data for that query, including Average Execution Time, Total Executions, and Rows Affected over time. Rows Affected The total ... The Query Analyzer provides a point-in-time snapshot of queries on the monitored database, enabling you to monitor SQL statements executed on a MySQL server and see details of each query, number of executions, and execution ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-data-drift-detection.html
You can monitor data drift in the model catalog and when running the ML_PREDICT_ROW and ML_PREDICT_TABLE routines. For the ML_PREDICT_ROW and ML_PREDICT_TABLE routines, the options parameter includes the additional_details boolean value. Run the ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
The larger default values for these disk parameters compared to the default values for the corresponding memory parameters (memory_temptable_create_cost, memory_temptable_row_cost) reflects the greater cost of processing disk-based tables. DBAs can ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...