专注于互联网--专注于架构

mysql执行sql文件:mysql 动态执行SQL

在mysql存储过程中动态执行sql文mysql> PREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';mysql> SET @a = 3;mysql> SET @b = 4;mysql> EXECUTE stmt1 USING @a, @b;mysql> SET @a = 'select * from table1 ';mysql> SET @b = 'where column1>10 limit 1';mysql> SET @a [阅读全文] [PDF]