UPDATE tab_dog_appraisal_info set 鉴定时间 = "" where 鉴定时间 = "-  -";
UPDATE tab_dog_appraisal_info set 鉴定时间 = REPLACE(鉴定时间, ' ', '');
UPDATE tab_dog_appraisal_info set 鉴定时间 = "2008-3-1" where 鉴定时间 = "2008-3-";
UPDATE tab_dog_appraisal_info set 鉴定时间 = "2014-03-1" where 鉴定时间 = "2014-03";
UPDATE tab_dog_appraisal_info set 鉴定时间 = REPLACE(鉴定时间, '年', '-');
UPDATE tab_dog_appraisal_info set 鉴定时间 = REPLACE(鉴定时间, '月', '-');
UPDATE tab_dog_appraisal_info set 鉴定时间 = REPLACE(鉴定时间, '日', '-');
INSERT INTO dog_appraisal_appraiser (
	pedigree_certified,
	identify_site,
	identifier1,
	identifier2,
	identifier3,
	identify_time,
	create_time,
	update_time,
	del_flag
) SELECT
	血统证书号,
	鉴定地点,
	鉴定人_1,
	鉴定人_2,
	鉴定人_3,
	case when 鉴定时间 = '' then null else 鉴定时间 end,
	case when 添加日期 = '' then null else 添加日期 end,
	case when 修改日期 = '' then null else 修改日期 end,
	del_tag
FROM
	tab_dog_appraisal_info;
