Select Code to Download

CREATE TABLE `theTable` (
  `col_1` smallint(5) unsigned NOT NULL default '0',
  `col_2` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`col_1`,`col_2`)
) TYPE=MyISAM

    #method 1 - Perl intersection using @col arrays
    $sql = "SELECT col_2 FROM theTable WHERE col_1 = ?";
...
    }
    $end_3 = new Benchmark;
    $diff = timediff($end_3, $start_3);