普通的insert:
=CONCATENATE(“INSERT INTO user (role_group, role_group_code, role_name, user_name, user_code, email, phone_no, position,wechat_no) VALUES (
'”,B2,"’,’",C3,"’,’",D3,"’,’",E3,"’,’",F3,"’,’",G3,"’,’",H3,"’,’",I3,"’,’",J3,"’);")
普通的更新:
=CONCATENATE(“update gusers_info set user_mobile=’”,D2,"’ where user_mobile=’",E2,"’ and user_id=",F2,";")
时间处理–与TEXT结合:
=CONCATENATE(“update KKk create_time_scene = “,TEXT(G1,“yyyy-MM-dd HH:mm:ss”),” where scene_code_fk =’”,A2,"’ and scene_version_fk = ‘",C2,"’;")