Help for this page

Select Code to Download


  1. or download this
    $stmt =qq/LOAD DATA LOCAL INFILE "..\/$cvstoupload" 
INTO TABLE statezones FIELDS TERMINATED BY "," OPTIONALLY 
ENCLOSED BY """" LINES TERMINATED BY "\r" IGNORE 1 LINES/;
  2. or download this
    STATE,ABBREV,ZONE
Alabama,AL,2
...
Colorado,CO,2
Connecticut,CT,2
Delaware,DE,2
  3. or download this
    Alabama,AL,2
Alaska,AK,4
Arizona,AZ,3
  4. or download this
    #!/usr/bin/perl -T

...

   return ($newfile);
}