Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-triggers.html
Definer The account of the user who created the trigger, in 'user_name'@'host_name' format. row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 ...
https://dev.mysql.com/doc/refman/9.7/en/temporary-files.html
InnoDB user-created temporary tables and on-disk internal temporary tables are created in a temporary tablespace file named ibtmp1 in the MySQL data directory. For some statements, MySQL creates temporary SQL tables that are not hidden and have ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-extension-objects-examples.html
Example 11.1 Creating and Registering Extension Objects - Python This example creates a function hello_world() which is made available through the user-defined MySQL Shell global object demo. The code creates a new extension object and adds the ...
https://dev.mysql.com/doc/mysql-errors/9.7/en/global-error-reference.html
Error number: 36; Symbol: EE_FAILED_TO_CREATE_TIMER; Message: Failed to create timer (OS errno %d). Error number: 38; Symbol: EE_FAILED_TO_CREATE_TIMER_QUEUE; Message: Failed to create timer queue (OS errno %d). Error number: 40; Symbol: ... This ...
https://dev.mysql.com/doc/refman/9.7/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/9.7/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges. What's Next Learn about the available LLMs, embedding Models, and ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-0.html
Note MySQL HeatWave User Guide has been restructured and improved to provide better visibility of high-level tasks. Note These release notes were created with the assistance of MySQL HeatWave GenAI. Additionally, NL2ML offers a chat-bot interface ...MySQL HeatWave AutoML MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave MySQL HeatWave AutoML MySQL HeatWave AutoML now supports the recording of hyperparameters of trained models, enhancing the transparency and reproducibility of machine learning ...