付出了很大的努力,是的。
SET @db = 'db1';SET @q = CONCAt('SELECt * FROM ', @db, '.mycol');PREPARE stmt FROM @q;EXECUTE stmt;DEALLOCATE PREPARE stmt;
付出了很大的努力,是的。
SET @db = 'db1';SET @q = CONCAt('SELECt * FROM ', @db, '.mycol');PREPARE stmt FROM @q;EXECUTE stmt;DEALLOCATE PREPARE stmt;