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