delimiter //
CREATE PROCEDURE procedure1()
begin
        DECLARE str char(64);
        DECLARE cur CURSOR for select TABLE_NAME FROM information_schema.columns WHERE column_name = 'mycolum1' AND TABLE_SCHEMA='mydb';
        OPEN cur;
                read_loop: loop
                        FETCH cur INTO str;
                        CREATE TRIGGER str BEFORE INSERT ON str FOR EACH ROW SET NEW.mycolum1=sha1(NEW.mycolum1);
                END LOOP;
        CLOSE cur;
end //