Eval MySQL/MariaDB

Moki Lv6
  2022-10-21 06:09:33 2022-10-21 06:09:33 Created   2022-10-21 06:09:33 2022-10-21 06:09:33 Updated   

Procedure:

1
2
3
4
5
6
7
8
9
10
11
DELIMITER $

CREATE procedure `eval`(IN sqlParam longtext)
BEGIN
    SET @sql = sqlParam;
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END$

DELIMITER ;

Example use:

1
CALL eval('SELECT 1 FROM dual');
Recommendations
Temporary disable write to binlog Temporary disable write to binlog MySQL column temporary collation MySQL column temporary collation Calculate string occurences Calculate string occurences
Recommendations
Temporary disable write to binlog Temporary disable write to binlog MySQL column temporary collation MySQL column temporary collation
On this page
Eval MySQL/MariaDB