excel 公式2列合并
=A2&"="&C2
="UPDATE comm_department SET parent_id='"&D2&"' WHERE id='"&A2&"';"
=IF(D3=1,0,IF(D3=0,1,"")) 0变1 ,1变0
=A2&"="&C2
="UPDATE comm_department SET parent_id='"&D2&"' WHERE id='"&A2&"';"
=IF(D3=1,0,IF(D3=0,1,"")) 0变1 ,1变0