David,
Try something a bit different
===
use DBI;
# Added: This will probably break you in lots of
places,
# but use strict is worth it.
use strict;
# Strict on $infile
my $infile = "/cadfs8/sys/dnazary/mysql_test_data1";
# Strict on $dbh
my $dbh =
y, June 10, 2003 9:44 AM
To: Nazary, David; [EMAIL PROTECTED]
Cc: Nazary, David
Subject: Re: Inserting data into MySql using perl script
On Monday June 9 2003 3:49 pm, Nazary, David wrote:
> Hi,
>
> I am unable to insert data into MySql with following script:
>
> #!/usr/bin/pe
On Monday June 9 2003 3:49 pm, Nazary, David wrote:
> Hi,
>
> I am unable to insert data into MySql with following script:
>
> #!/usr/bin/perl
> use DBI;
> use Mysql;
> $infile = "/cadfs8/sys/dnazary/mysql_test_data1";
> $dbh = DBI ->connect('DBI:mysql:dnazary_test:localhost', 'root', 'mysql');
> o
auto_increment |
| name | varchar(10) | | | ||
| model | varchar(10) | | | ||
++-+--+-+-++
3 rows in set (0.01 sec)
Regards
David
-Original Message-
From: Roberto Ruiz [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 7:34 PM
To: [EMAIL PROTECTED]
Hi,
On Mon, Jun 09, 2003 at 04:49:41PM -0700, Nazary, David wrote:
>
> I am unable to insert data into MySql with following script:
>
> #!/usr/bin/perl
> use DBI;
> use Mysql;
Not needed, you may comment it out.
> $infile = "/cadfs8/sys/dnazary/mysql_test_data1";
> $dbh = DBI ->connect('DBI:m
Hi,
I am unable to insert data into MySql with following script:
#!/usr/bin/perl
use DBI;
use Mysql;
$infile = "/cadfs8/sys/dnazary/mysql_test_data1";
$dbh = DBI ->connect('DBI:mysql:dnazary_test:localhost', 'root', 'mysql');
open (IFH, $infile) or die ("Could not open input file.");
foreach ()
