Hi, I am using perl and mysql to update list of bounced emails. Now issue is that I can insert data of unique emails in table. But I am now trying to do this that it should run select records from table A and then insert only the new ones in Table B and update the old ones number and latest date. Now when I try to use 2 select queries in $dbh and assign to $skh1 and $skh2 then when I run execute and try to get data from both queries, $skh2 gives error
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
now can you please tell me how can I compare 2 tables and update only the old ones date and insert new ones. I think I need to run 2 queries for it and then compare and update insert. But how can I run 2 select queries with 1 db handle and update the table B. or is there any other way for it. Kindly help me in this regards as I am new in perl/mysql.