delete inner的写法

zhgc

1. delete a from sfc.r_data_input_t  a  inner join
   
2. sfc.c_temp_t b on a.mac1=b.field_name
   
3. where b.compare='T20200403'

复制代码

zhgc

1. UPDATE SFC.R107 INNER JOIN sfc.r_data_input_t ON R107.SERIAL_NUMBER=r_data_input_t.mac1
   
2. SET R107.model_name='IPC007_A01NEW',
   
3. R107.mo_number='A20040301',
   
4. R107.special_route=466,
   
5. R107.rework_no='F13145200407',
   
6. R107.shipping_sn=r_data_input_t.ssn1
   
7. where r_data_input_t.mo_number='A20040301'

复制代码

zhgc

1. DELETE FROM test.testA,
   
2.             test.testB
   
3. USING       test.testA
   
4. JOIN        test.testB ON test.testA.colA = test.testB.colB;

复制代码

可以删多表，没有验证过！

zhgc

syant

update  SFC.r108 b
inner join sfc.r107 a  on   a.serial_number=b.serial_number
set b.key_part_sn=(select id2 from sfc.mes_data_key_t where mo='SIGNALINKS-DSIM-ICCID' and id2 like concat(b.key_part_sn,'_')),b.emp_no='SSSSS'
WHERE a.MO_number='20240408001' and b.key_part_no='ICCID3' and length(b.key_part_sn)=19

update  SFC.r108 b
inner join sfc.r107 a  on   a.serial_number=b.serial_number
set b.carton_no=(select id3 from sfc.mes_data_key_t where mo='SIGNALINKS-DSIM-ICCID' and id2= b.key_part_sn )
WHERE a.MO_number='20240408001' and b.key_part_no='ICCID3' and length(b.key_part_sn)=20

update  SFC.r108 b
inner join sfc.r107 a  on   a.serial_number=b.serial_number
set b.carton_no=(select id1 from sfc.mes_data_key_t where mo='SIGNALINKS-DSIM-ICCID' and sn= b.key_part_sn )
WHERE a.MO_number='20240408001' and b.key_part_no='ICCID2' and length(b.key_part_sn)=19