MySQL在表字段原数据后加一个字符串 查询数据 select cust_name from bg_cust_info where for_short="金马衡器"; 在表字段原数据后加一个字符串 update bg_cust_info set cust_name=concat(cust_name,'@qq.com') where for_short="金马衡器";