Help for this page

Select Code to Download

Select or download this

    CREATE TABLE `table1` (
        ......
...
        `id` int(8) PRIMARY KEY AUTO_INCREMENT NOT NULL,
        `property` varchar(50)
    ) ENGINE=InnoDB;

Select or download this

    my ($pid) = $db->query(<<END_SQL, $property)->list;

...
        $db->query("INSERT INTO `table2` (`property`) VALUES (?)", $pr
+operty);
        $pid = $db->last_insert_id();
    }