Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...It ... SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A user variable referenced by a statement in a stored procedure has its type ... A ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. (Bug #37621360) Installation Notes Debian packages for installing MySQL can now be run by users other than root. (Bug #37478594) InnoDB: Creating a secondary index ...Compilation Notes Configuration Notes InnoDB Notes Installation Notes Packaging Notes Functionality Added or Changed Bugs Fixed Compilation Notes macOS: It is now possible to compile the server on MacOS using ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-ml-model-metadata.html
build_timestamp: number A timestamp indicating when the model was created (UNIX epoch time). The model_metadata column in the model catalog allows you to view detailed information on trained models. For example, you can view the algorithm used to ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-event-handlers-email-group-controls-reference.html
Figure 22.2 Email Notification Groups section Table 22.2 Email Notification Groups List Controls Name Description Create Notification Group button Opens the Create Notification Group dialog. Creating an Email Notification Group You can define email ... This section describes the controls on the Email Notification Group ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
See Creating an IAM Role to Access an Amazon S3 Bucket, Creating a DB System, and Editing a DB System. Create a new database or use an existing database to bulk ingest data. For example, the following query creates a new database, airportdb, and ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
(Although you can write an ON DELETE or ON UPDATE clause as part of the REFERENCES clause, it is also ignored.) This syntax creates a column; it does not create any sort of index or key. row *************************** Table: shirt Create Table: ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
ARRAY is not supported except when used to create a multi-valued index in one of these statements, in which case it is required. Note CONVERT(), unlike CAST(), does not support multi-valued index creation or the ARRAY keyword. Other Uses for Cast ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. Only undo tablespaces created using CREATE UNDO TABLESPACE syntax can be dropped. Similar to the system tablespace, ...The ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
Creating a FULLTEXT Index that uses the MeCab Parser To create a FULLTEXT index that uses the mecab parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. For a stopword list applicable to Japanese, you must create your ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...