|cutstr:40:'...' 截取

insert into T_CARD(FCARDNO,FCARDPASS,FBATCHCODE)
select c_CARDNO,c_CARDPASS,b.FBATCHCODE
from t_CardBatch b
把一个表的字段搬迁到另一个表（那个是b 是重名相同的字段）

TRUNCATE member_jdtiao;
INSERT member_jdtiao(id,uid,block,`point`,petName,title,`Y`,`M`,`D`,tmpl,`type`,dateline,lastupdate)
SELECT id,userId,blockId,pointId,petName,topText,
SUBSTR(`birthday`,1,4) Y,SUBSTR(`birthday`,6,2) M,SUBSTR(`birthday`,9,2) D,
CONCAT('Process/petFace/',FROM_UNIXTIME(`createTime`,'%Y/%c/%e/'),`petFace`) tmpl,isUploadFile,
createTime,lastupdate FROM processbar
TRUNCATE member_sign;
INSERT INTO member_sign(id,uid,dateline,`sign`) SELECT id,userId,createTime,signhtml FROM signhtml;