1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
#!/usr/bin/perl
# Create a sample database zipcodes.* using DBD::DBM,
# which ships with DBI.
# ------ use/require pragmas
use strict; # better compile-time checking
use warnings; # better run-time warnings
use DBI; # database interface
# ------ define variables
my $dbh = ""; # DBI handle
# ------ create database sample table
$dbh = DBI->connect("dbi:DBM:");
$dbh->do(qq{
CREATE TABLE
zipcodes
(
last_modified TEXT
)
});
$dbh->do(qq{
INSERT INTO
zipcodes
VALUES
(
'1970-01-01'
)
});
|
