【Mysql数据库】Mysql通用存储过程，添加列，删除列，创建索引

AddColumnUnlessExists【补充创建字段】

CREATE DEFINER=`aicenter`@`%` PROCEDURE `AddColumnUnlessExists`(
    IN tableName tinytext,
    IN fieldName tinytext,
    IN fieldDef text)
begin
    IF NOT EXISTS (
        SELECT * FROM information_schema.COLUMNS
        WHERE column_name=fieldName
        and table_name=tableName
        and table_schema= DATABASE()
        )
    THEN
        set @ddl=CONCAT('ALTER TABLE ',DATABASE(),'.',tableName,' ADD COLUMN ',fieldName,' ',fieldDef);
        prepare stmt from @ddl;
        execute stmt;
    END IF;
end

调用实例：

call AddColumnUnlessExists('account, 'verify_time','datetime NULL COMMENT ''核实时间'' AFTER `create_user`');

call AddColumnUnlessExists('account', 'verify_marks','varchar(200) NULL COMMENT ''核实说明