Search Results
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
Uninstalling Loadable Functions To remove a loadable function, use the DROP FUNCTION statement. For example: DROP FUNCTION metaphon; DROP FUNCTION has these effects: It unloads the function to make it unavailable. For this reason, DROP FUNCTION ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
Use the available utility SQL stored procedure `sys.TRAIN_TEST_SPLIT` to do an 80-20 train-test split on the integrated full table.\n\n```sql | | \nCALL sys.TRAIN_TEST_SPLIT('food_delivery_db.integrated_table', NULL, JSON_OBJECT('task', ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-rejoin.html
The auto-rejoin attempts and the time between them are called the auto-rejoin procedure. If you do want to intervene to take the member offline during the auto-rejoin procedure, the member can be stopped manually at any time by using a STOP ... The ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
For example, consider the following stored routine: CREATE PROCEDURE test_routine() BEGIN SELECT name FROM TestTable ORDER BY name; SELECT COUNT(name) FROM TestTable; END This routine actually needs to be executed on the MySQL Server as a single ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
For example, consider the following stored routine: CREATE PROCEDURE test_routine() BEGIN SELECT name FROM TestTable ORDER BY name; SELECT COUNT(name) FROM TestTable; END This routine actually needs to be executed on the MySQL Server as a single ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
To update the tables to the expected structure, perform the MySQL upgrade procedure. The procs_priv table applies to stored routines (stored procedures and functions). A privilege granted at the routine level applies only to a single procedure or ...
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. (The existing table is hidden until the temporary table is dropped.) InnoDB does not support compressed temporary tables. Dropping ... You can use the TEMPORARY keyword when creating a ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> ... The ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...We solve this by introducing a separate MEM_ROOT object for storing the bind parameters array, which object can be cleared (deallocating the memory) on each call to mysql_stmt_bind_param() or ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
Dropped Fabric support in MySQL Workbench 6.3.9; support in older versions of MySQL Workbench is unchanged. Package and Build Related Changes Linux: Fedora 23 support dropped, Fedora 25 support added. OS X / macOS: Version 10.7 (Lion) and 10.8 ...