msyql----编辑字段

delimiter $
drop procedure if exists pro_put_column;
create procedure pro_put_column()
BEGIN

    if exists(select column_name from information_schema.columns where table_name = 'bizlog' and column_name = 'qqq') 
    THEN
	 alter table bizlog CHANGE qqq aaa BIGINT;
        
    ELSE
         alter table bizlog add column qqq BIGINT;
    end if;

END $
delimiter ;

call pro_put_column();

如果表：bizlog 存在名字为qqq的字段

修改qqq字段——>aaa

否则：增加字段qqq