INSERT INTO t_sale_company_customer (
id,
company_name,
juridical_name,
tel,
address,
seller_id,
seller_name,
manage_id,
manage_name,
team_id,
team_name,
area_id,
area_name,
type
) SELECT
substring(MD5(RAND()),1,20),
y.compony_name,
y.sign_kp AS juridical_name,
y.tel,
y.compony_addr,
y.seller_id,
y.seller_name,
y.manage_id,
y.manage_name,
y.team_id,
y.team_name,
y.area_id,
y.area_name,
3
FROM
t_sale_xinqian_yj y
WHERE y.examine_status = 1
mysql 新增查询出来的结果
最新推荐文章于 2023-08-26 10:26:37 发布