mysql修改字段类型，如何判断字段存在

set names gbk;
USE `anxiesoft`;

-- ----------------------------
-- Procedure structure for sp_update_table_field
-- ----------------------------
DROP PROCEDURE IF EXISTS `sp_update_table_field`;
DELIMITER ;;
CREATE DEFINER=`mysql`@`%` PROCEDURE `sp_update_table_field`()
BEGIN
IF NOT EXISTS(SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='anxiesoft' AND table_name='domaininfo' AND COLUMN_NAME='coding') THEN
	alter table `domaininfo` add `coding` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL;
END IF;
END;;
DELIMITER ;
call sp_update_table_field();
DROP   PROCEDURE   IF   EXISTS   `anxiesoft`.`sp_update_table_field`;