I obtained a job to do load testing on database. The issue is I’ve 3 queries that have to run one after one other to get the outcome as under sequence.
UPDATE db_swim_dev.ios_upgrade_css_site_selection SET
pre_check='PROCESSING' WHERE id='Dynamic Worth have to fetch
from CSV';INSERT INTO db_swim_dev.tbl_ios_css_checks (id, hostname,
r0_state, r1_state, device_type, model, issu_ready,
licence_advancedmetroipaccess, licence_status, device_model,
software_state, cust_special, power_state, fan_state,
output, ios_image_update, job_id, site_master_id, rcount,
mmcblk0) VALUES ('', 'dynamic worth have to fetch from CSV', '',
'', '920o', 'V156_2_SP_SR680887239_8', '0', '0', '1', '0', '0', '0',
'0', '0',
'a:3:{s:11:"device_type";s:4:"920o";s:14:"licence_status";i:1;s:7:"mmcblk0";i:0;}',
'0', '246', '19442', '0', '0');UPDATE db_swim_dev.ios_upgrade_css_site_selection SET
pre_check='FAILED' WHERE id='Dynamic worth have to fetch from
CSV';
I’m not certain how to try this. I attempted to run all of the queries collectively getting an error. If anybody has encountered the identical state of affairs please let me know the right way to make this work.