MySQL遍历表

尝试这个：

delimiter //drop procedure if exists hunt //create procedure hunt()begin    DECLARE done int default false;    DECLARE table_name CHAr(255);    DECLARE cur1 cursor for SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS         WHERe TABLE_SCHEMA = "wholesale_production" and COLUMN_NAME LIKE "%first%" ;    DECLARE ConTINUE HANDLER FOR NOT FOUND SET done = TRUE;    open cur1;    myloop: loop        fetch cur1 into table_name;        if done then leave myloop;        end if;        set @sql = CONCAt('select * from `wholesale_production`.', table_name, ' where created_at >= '2012-10-01');        prepare stmt from @sql;        execute stmt;        drop prepare stmt;    end loop;    close cur1;end //delimiter ;call hunt();