如何在MySQL存儲過程中使用動態(tài)SQL如何在MySQL存儲過程中構(gòu)建和使用動態(tài)SQL？
3 回答
躍然一笑
TA貢獻(xiàn)1826條經(jīng)驗(yàn) 獲得超6個贊
mysql> PREPARE stmt FROM -> 'select count(*) -> from information_schema.schemata -> where schema_name = ? or schema_name = ?';Query OK, 0 rows affected (0.00 sec)Statement prepared mysql> EXECUTE stmt -> USING @schema1,@schema2+----------+| count(*) |+----------+| 2 |+----------+1 row in set (0.00 sec)mysql> DEALLOCATE PREPARE stmt;
stmt
呼如林
TA貢獻(xiàn)1798條經(jīng)驗(yàn) 獲得超3個贊
可以使用用戶定義的變量在動態(tài)語句之外傳遞。
Server version: 5.6.25-log MySQL Community Server (GPL)
mysql> PREPARE stmt FROM 'select "AAAA" into @a';
Query OK, 0 rows affected (0.01 sec)
Statement prepared
mysql> EXECUTE stmt;
Query OK, 1 row affected (0.01 sec)
DEALLOCATE prepare stmt;
Query OK, 0 rows affected (0.01 sec)
mysql> select @a;
+------+
| @a |
+------+
|AAAA |
+------+
1 row in set (0.01 sec)
添加回答
舉報(bào)
0/150
提交
取消