$sth->execute;
$sth->bind_columns(\my $x, \my $y);
while ($sth->fetch) {
   # use $x and #y
}