On Mon, 2007-12-31 at 00:52 -0800, aclhkaclhk wrote:
Hi Peter
> insert.pl
>use DBI;
> $dbh = DBI->connect("DBI:CSV:f_dir=/root/csv/
> db;csv_sep_char=",";csv_quote_char=;csv_eol=\n")
> or die "Cannot connect: " . $DBI::errstr;
I suggest you check the double-quotes used in the con
aclhkaclhk wrote:
I have a csv file. I defined the column names inside the perl script
but "sql insert" does not work.
That's because you defined the column names for a table called "passwd"
and then tried to do an insert on a table called "b". You need to
define the column names for the tabl
I have a csv file. I defined the column names inside the perl script
but "sql insert" does not work. If the csv has column names, the
script (without col names defined) works.
sql select works on both csv with or without column names.
* not working
/root/csv/db/b
1,peter
2,wilson
insert
