UPDATE account a,contact c SET a.contact=CONCAT(c.first_name,c.last_name) WHERE a.id = c.account
用到concat拼接字符串函数,concat(str1,str1,......)
UPDATE account a,contact c SET a.contact=CONCAT(c.first_name,c.last_name) WHERE a.id = c.account
用到concat拼接字符串函数,concat(str1,str1,......)
转载于:https://my.oschina.net/liangzh/blog/300699