DELIMITER $$
create procedure cur_update()
begin
 declare a tinyint unsigned;
 declare b varchar(128);
 declare c int unsigned;

 declare curl2 CURSOR for select cid from contents
   where updated > '2012-09-05';

 open curl2;

 LOOP
  fetch curl2 into c;
  select cid, name into a, b from categories order by rand() limit 1;
  update contents ct
    set ct.cate_id = a, ct.category = b
    where ct.cid = c;
end LOOP;

close curl2;
end$$

DELIMITER;

$ mysql -u root utf8_general_ci-db --default-character-set=utf8 <
  utf8_general_ci-db.sql