Query execution time and results whth multiple queries

themis's profile image themis posted 6 years ago in General Permalink

Hi,

Actually in HeidiSql

if i execute only one query in the query tab

delete from tbltest where idcustomer=1;

/ Affected rows: 2200 Found rows: 0 Warnings: 0 Duration for 1 queries: 0.124 sec. /

then a new query in the query tab

delete from tbltest where idcustomer=2;

/ Affected rows: 5000 Found rows: 0 Warnings: 0 Duration for 1 queries: 0.124 sec. /

if i execute the two queries in the query tab, i get the total result of the queries

delete from tbltest where idcustomer=1;

delete from tbltest where idcustomer=2;

/ Affected rows: 7200 Found rows: 0 Warnings: 0 Duration for 2 queries: 0.234 sec. /

is there a syntax where i can get the results of each query

delete from tbltest where idcustomer=1;

magic command in heidi : print result ?????

delete from tbltest where idcustomer=2;

magic command in heidi : print result ?????

/ Affected rows: 2200 Found rows: 0 Warnings: 0 Duration for 1 queries: 0.124 sec. /

/ Affected rows: 5000 Found rows: 0 Warnings: 0 Duration for 1 queries: 0.124 sec. /

My need is to execute complex scripts with hundred of queries for purge a base, and get the details of each of them

Sincerely yours, Themis

Please login to leave a reply, or register at first.