in reply to How to do Database checking through Perl?

Before updating, you can store the value into variable. After updation, You can execute the select query with the condition. For example, I am going to update the name.

Update names set first_name = 'irah';
After that,
select * from names where first_name = 'irah';

If the number of rows, not equal to zero, the values are updated. If the same value already (before updating) available, you can execute the same select query before updating and compare the number of rows before updating and after updating.

  • Comment on Re: How to do Database checking through Perl?