Mysql复制同一个表中的某些数据给其他列

场景是：有一个表需要根据一条数据（tray_code = ‘T0000004’）为基础模拟相同的数据给其他做批量测试使用，语句如下

update t_tray a, 

(select batch_num, soorDer_no, materiel_code, materiel_name, batch_no, spec_model, num 
from t_tray where tray_code = 'T0000004' ) b

set a.batch_num = b.batch_num, 
a.soorDer_no = b.soorDer_no,
a.materiel_code = b.materiel_code, 
a.materiel_name = b.materiel_name, 
a.batch_no = b.batch_no, 
a.spec_model = b.spec_model, 
a.num = b.num,
a.state = 1
where a.tray_code > 'T0003401'

先查出tray_code = 'T0000004’的数据，然后再统一赋值过去