DELIMITER $$
DROP PROCEDURE IF EXISTS `select_counts`$$
CREATE PROCEDURE `select_counts`()
BEGIN
  DECLARE done INT DEFAULT FALSE;
  DECLARE tn VARCHAR(1000);
  DECLARE cur1 CURSOR FOR select table_name from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='superudc_baza' order by table_name;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

DROP TABLE IF EXISTS `aaa`;

CREATE TABLE `aaa` (
  `tab_name` varchar(1000),
  `count1` varchar(1000)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

  OPEN cur1;

  read_loop: LOOP
    FETCH cur1 INTO tn;
    IF done THEN
      LEAVE read_loop;
    END IF;
SET @sql_query:=CONCAT("insert into aaa (tab_name,count1) select ",tn,",count(1) from ",tn);

PREPARE sql_query FROM @sql_query;
EXECUTE sql_query;
DEALLOCATE PREPARE sql_query;	

  END LOOP;

  CLOSE cur1;

END$$
DELIMITER ;