REPLACE INTO `t_cus_info` (
	`F_CUS_CODE`,
	`F_GENDER`,
	`F_STATE`,
	`F_CUS_NAME`,
	`F_PHONE`,
	`F_CUS_INTEGRAL`,
	`F_CREATETIME`,
	`F_UP_HP`,
	`F_CUS_GRADE_REL`,
	`F_LOGIN_PWD`,
	`F_PAY_PWD`,
	`F_SOURCE_ID`,
	`F_CUS_MER_REL`,
	`F_REGISTER_SHOP`,
`F_CUS_ACCOUNT_BALANCE`,
`F_UPDATE_TIME`,
	F_BABY_BIRTHDAY
) 
SELECT
	CONCAT(DATE_FORMAT(NOW(),'%Y%m%d'),t.F_PHONE ) F_CUS_CODE,
'1' F_GENDER,

	'0' F_STATE,
	t.F_CUS_NAME F_CUS_NAME,
	TRIM(t.F_PHONE) F_PHONE,
	trim(round(t.F_CUS_INTEGRAL) ) F_CUS_INTEGRAL,
	'20170621010101' F_CREATETIME,

'0' F_UP_HP,
'1' F_CUS_GRADE_REL,

 '3IhpBKacuTU=' F_LOGIN_PWD,
 '3IhpBKacuTU=' F_PAY_PWD,
 '3' F_SOURCE_ID,
 'KZ' F_CUS_MER_REL,
 
'2' F_REGISTER_SHOP,

AES_ENCRYPT(0,'ACCOUNT_KEY')  F_CUS_ACCOUNT_BALANCE,    ???????????????????????????

'20170620235959' F_UPDATE_TIME,


	DATE_FORMAT(t.F_BABY_BIRTHDAY, '%Y%m%d')  F_BABY_BIRTHDAY
FROM
	sheet2 t
WHERE
	T.F_PHONE IS NOT NULL
AND T.F_PHONE != ''