深圳全飞鸿

标题: delete inner的写法 [打印本页]

---

作者: zhgc    时间: 2020-4-3 14:23
标题: delete inner的写法

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    时间: 2020-4-7 20:36

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    时间: 2021-6-24 19:53

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

复制代码

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

---

作者: zhgc    时间: 2023-2-3 15:07

---

作者: syant    时间: 2024-4-16 08:07
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

---

欢迎光临 深圳全飞鸿 (http://www.nagomes.com/disc/)

Powered by Discuz! X3.2