— 给task表及子表添加字段
DELIMITER //
drop procedure if exists taskAddFieldPro//
CREATE PROCEDURE taskAddFieldPro()
BEGIN
DECLARE tableName varchar(50) default ”;
DECLARE done INT DEFAULT 0;
DECLARE taskCursor CURSOR FOR select table_name from information_schema.tables where table_schema=’uc_ipcc_cloud_ai’ and table_name like ‘tb_ucpaas_task_run%’;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
OPEN taskCursor;
REPEAT
FETCH taskCursor INTO tableName;
IF not done THEN
set @sql=concat(‘alter table ‘,tableName,’ add tel_time int(11) DEFAULT NULL COMMENT “通话时长，秒”‘);
PREPARE stmt from @sql;
execute stmt;
set @sql1=concat(‘alter table ‘,tableName,’ add hangup_type char(1) DEFAULT NULL COMMENT “挂断方式：0 主动挂断 1 被动挂断”‘);
PREPARE stmt1 from @sql1;
execute stmt1;
END IF;
UNTIL done END REPEAT;
CLOSE taskCursor;
END
//
DELIMITER;
CALL taskAddFieldPro();
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
文章由半码博客整理，本文链接：https://www.bmabk.com/index.php/post/17753.html
