#!/usr/bin/perl
use DBI;
my $database = "desired database";
my $dbhost = "desired database host";
my $username = "your username";
my $password = "your password";
my $data_source = "DBI:mysql:$database:$dbhost";
my $dbh = DBI->connect($data_source, $username, $password);
my $sourcefile = "the name
Thanks to everyone who replied. I have been able to clean up the code and
it works fine now.
Thanks again.
On Fri, 18 Jul 2003, Rudy Metzger wrote:
> Can you please post the source code?
>
> In any case, I would consider using DBI.
>
> Cheers
> /rudy
>
> -Original Message-
> From: Ashw
Can you please post the source code?
In any case, I would consider using DBI.
Cheers
/rudy
-Original Message-
From: Ashwin Kutty [mailto:[EMAIL PROTECTED]
Sent: donderdag 17 juli 2003 17:12
To: [EMAIL PROTECTED]
Subject: Select via Perl
I am trying to read a file and see if the content
Ashwin Kutty wrote:
I am trying to read a file and see if the contents of it exists in the DB
or not and am trying to do it via a Select.
I try to do a select * into outfile /tmp/result.txt from table where field
like "%$var%"; but it always goes through the first two lines of the input
file and
