Re: DBD::mysql trouble


P is for Practical
	PerlMonks

Re: DBD::mysql trouble

by venkatesan_G02 (Sexton)

on Sep 23, 2009 at 11:11 UTC ( [id://796934]=note: print w/replies, xml )

Need Help??

in reply to DBD::mysql trouble

I think you can try this code.

my $dbh = DBI->connect('DBI:mysql:yourmysqldatabasename','root','passw
+ord')||die "can't connect to dabase:$DBI::errstr";

my $dbh=$dbh->prepare("UPDATE TableName SET ColumnName=\"$value\" wher
+e ColumnName=$value2 ");

$dbh->execute();

$dbh->disconnect();
[download]

As mentioned by zwon (Deacon), quote your values.

Also, the command to clear screan in windows is system("cls")

Thanks