Get Advance Warning Of Rows Affected

[Chirantan Thakkar]

Hi,

There is no way MySQL provides to get the number of rows going to be affected in advance for the Update Query.

SQLyog just displays the messages returned by the MySQL Server. So until You run the Query, You can not know the number of rows going to be affected.

But You can know the no of rows in advance in another way.

Suppose,

You have an Update Query : Update mytable Set itemname = 'skc' where itemid < 10; Convert it to : SELECT count(*) FROM mytable WHERE itemid < 10;

[Author]

Posts