Форум пользователей MySQL

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`one`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `one`()
BEGIN
  DECLARE p_item_id,p_c_doc_id,p_parent,p_percent INT default 0;
  DECLARE p_count INT default 0;
  DECLARE cur1 CURSOR FOR SELECT id FROM items WHERE percent=-1 limit 1;

  OPEN cur1;

  BEGIN
    DECLARE EXIT HANDLER FOR NOT FOUND BEGIN END;
    LOOP
      FETCH cur1 INTO p_item_id;
    SELECT COUNT(doc_id)  into p_count FROM items_hashes_tmp WHERE doc_id=p_item_id;
    SELECT t1.doc_id, count(t1.word_hash) AS parent INTO p_parent,p_c_doc_id

      FROM items_hashes t1, items_hashes_tmp t2

      WHERE t2.doc_id=p_item_id and t1.word_hash=t2.word_hash

      GROUP BY t1.doc_id

      ORDER BY parent DESC

      LIMIT 1;
select curtime();
    END LOOP;
  END;

  CLOSE cur1;

END$$

DELIMITER ;