select * from device where serial_number='000019' and type='41431' -- 1220 38055 -- 1242 41431 select type from device where serial_number='310570' update device set type = 41431 where serial_number='310570';
select * from device where serial_number='000019' and type='41431' -- 1220 38055 -- 1242 41431 select type from device where serial_number='310570' update device set type = 41431 where serial_number='310570';
Comments