When I run this query in MySQL it deletes records it deletes only /nas which is wanted done. I also hardcoded the values for NOT IN sub-select statement and deletes only /nas. But, when I use the place holder in my code, for some reason it deletes all records.
I guess, I will try debugging...
I am trying to delete some records that satisfy a conditional clause, but the delete statement deletes all records instead. Can someone please help?
Here is the snippet of my code:
use strict;
use warnings;
use DBI;
my $dsn = "DBI:mysql:database=netbackup;host=localhost";
my $dbh =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.