The FLUSH statement has several variant forms that clear or reload various internal caches, flush tables, or acquire locks. However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. See Section The mysqladmin utility provides a command-line interface to some flush operations, using commands such as flush-hosts , flush-logs , flush-privileges , flush-status , and flush-tables.
MySQL Stored Function
Creating Stored Procedures in MySQL Using HeidiSQL 4's Stored Routine Editor — kohlsconnection.info
SET forms of the statement insert rows based on explicitly specified values. In MySQL 8. For the reasons for this, see Section When inserting into a partitioned table, you can control which partitions and subpartitions accept new rows.
MySQL CREATE PROCEDURE
Join Stack Overflow to learn, share knowledge, and build your career. Connect and share knowledge within a single location that is structured and easy to search. Functions are easy to call inside a select loop, but they don't let you run inserts, updates, deletes, etc. They are only useful for query operations.