Richard Reina wrote:
>
> Can someone send me a very simple perl script that connects to a mysql
> database and modifies a table.
use DBI;
use strict;
my $dbh = DBI->connect('DBI:mysql:database', 'username',
'password');
my $sth = $dbh->prepare("insert into tablename
(fname,lname,email)
values
('Rich','Bowen','junkmail@stripped')
");
$sth->execute;
That's about as simple as it gets.
Rich
--
It seems to me as we make our own few circles 'round the sun
We get it backwards and our seven years go by like one
--Rush, 'Dog Years' (Test for Echo, 1996)
