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;本文共 236 字,大约阅读时间需要 1 分钟。
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;转载于:https://www.cnblogs.com/jmbkeyes/p/4226029.html