Help for this page

Select Code to Download


  1. or download this
    SELECT extracted_ads_id, prop_street_no, prop_street_name
FROM extracted_ads_tbl 
WHERE pin-on-off=0
  2. or download this
    INSERT INTO enhanced_ads_tbl 
(enhanced_ad_id,extracted_ads_id,pin) 
VALUES (NULL,?,?)
  3. or download this
    ....snip....
my $query1 = "SELECT field1,field2,field3 FROM table WHERE `flag`=0";
...
   $sth2->execute($var1);
   ....snip....   
   }