Limo has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to learn how to use DBI and DBD::CSV. But, I can't get past the first page of the documentation. The example from the docs:
"Creating a database handle....snip" use DBI; use DBI::CSV; my $dbh = DBI->connect( "DBI:CSV:");
which apparently is the default current directory. I have full privileges in the directory that I'm working in.
"You can create and drop tables with commands like the following:" $dbh->do("CREATE TABLE new_table (id 1, name new(64))");
Well, running this returns the following error:
DBD::CSV::db do failed: Parse error near 1, name new(64)) at /usr/lib/perl5/site_perl/5.6.0/DBD/File.pm line 164.
I'm running 5.6; could this be my problem? I don't see any references to incompatibility with 5.6.

Replies are listed 'Best First'.
RE: Basic DBI question
by merlyn (Sage) on Sep 22, 2000 at 06:15 UTC
Re: Basic DBI question
by Limo (Scribe) on Sep 22, 2000 at 06:17 UTC
    Yay, I thought that they meant " NAME THIS USING CHARACTER(S)" Thanks, once again!
      ....as well as "INTEGER" meaning, "use an integer here".......