MySQL execute dynamic sql script.

SET @sql = (SELECT IF(
(SELECT COUNT(*)
FROM usher_network_log
) > 1000000,
"SELECT 0",
"select * from Configuration"
));

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

posted on 2015-01-15 13:09  jmbkeyes  阅读(410)  评论(0编辑  收藏  举报

导航