I received 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 end result as beneath 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 learn how to make this work.
