将查询结果代替原来的values,字段 一 一对应,即可完成批量插入数据
insert into device_status (device_type,device_id,status_)
SELECT 2 as device_type, device_id as device_id, 0 as status_
FROM devices
将查询结果代替原来的values,字段 一 一对应,即可完成批量插入数据
insert into device_status (device_type,device_id,status_)
SELECT 2 as device_type, device_id as device_id, 0 as status_
FROM devices