mysql修改，插入两张表数据



UPDATE aaa a ,aaa b
SET a.user_id='11'
WHERE  a.store_id=b.store_id;

----;
---;
UPDATE aaa a INNER JOIN agent b

set a.user_id='11'  ;
------------;
---------;

insert into aaa (
store_id
)
select agent_id    from  agent  as store_id;

---------;
UPDATE aaa a INNER JOIN agent b

set a.user_id='11' where 
a.store_id=b.agent_id  and
b.agent_id= '1-6HQQ5O3'

-------------;

------------;

insert into basic_user_store (store_id,user_id)
(
  select bcc.ORG_ID ,'w_fk_dsq'from basic_crm_channel bcc,area a where
bcc.area_num=a.id and a.id=12 and
bcc.channel_type=1
);