Aug-15-2022, 01:39 PM
Hello,
I have a sql file with ~ 50 lines of update\delete\set commands
everything is config to work according to the router ID
Thanks,
I have a sql file with ~ 50 lines of update\delete\set commands
everything is config to work according to the router ID
set @ID = (select rou_id from Company1.router where rou_serial_no like '%SN123456%'); ## put here the Rou Serial number! delete FROM israel_v7.history_router where rou_id=@ID and com_id=@OldCompany; . . . Update Company1.router set Company1.router.ROU_STATE = @State where Company1.router.ROU_ID = @ID;can I write a python code where I enter the serial_number --> save it as @ID then run the all sql file according to the Serial I have entered?
Thanks,