INSERT INTO dog_color_mark (
	id,
	dog_color_mark_code,
	dog_color_mark_cn,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	UUID(),
	abbreviate_english,
	explain_chinese,
	1 create_by,
	SYSDATE() create_date,
	1 update_by,
	SYSDATE() update_date,
	'' remarks,
	0 del_flag
FROM
	dbo.tab_color_and_badge