Postal addresses

require('DBI');
 
var db = %s'DBI'.connect('DBI:mysql:database:server','login','password');
 
var statment = <<'EOF';
CREATE TABLE `Address` (
    `addrID`       int(11)     NOT NULL   auto_increment,
    `addrStreet`   varchar(50) NOT NULL   default '',
    `addrCity`     varchar(25) NOT NULL   default '',
    `addrState`    char(2)     NOT NULL   default '',
    `addrZIP`      char(10)    NOT NULL   default '',
    PRIMARY KEY (`addrID`)
);
EOF
 
var exec = db.prepare(statment);
exec.execute;

Last updated