I found http://www.perl.com/pub/a/2003/09/03/perlcookbook.html and installed the
SQLite module, thinking it would be a way into learning about the DBI. I have some
questions.
my $dbh = DBI->connect("dbi:SQLite:ipk.dat", "", "",
{RaiseError => 1, AutoCommit => 1});
AutoCommit=>1 means the entries are automatically numbered..right? so
$dbh->do("CREATE TABLE names (id INTEGER PRIMARY KEY, name)");
$dbh->do("INSERT INTO names VALUES (NULL, 'Dan')");
if you insert "NULL" into the first column, where does the column number come from? Or
is that part of the AutoCommit magic?
TIA
Owen
