用sql脚本安全添加字段
create procedure safe_add_col(tname varchar(50),cname varchar(50))
begin
set @a = '';
select column_name into @a
from information_schema.columns
where table_name = tname and column_name = cname;
if @a = '' then
alter table tbl_application_source_down add import_batch varchar(14) default '' not null;
end if;
end;
call safe_add_col('user','real_name');
drop procedure if exists safe_add_col;
bitscn.com