=CONCATENATE("update supplier set ddd='",A1,"' where aaa='",B1,"';") 转载于:https://www.cnblogs.com/duwamish/p/10444221.html