Re: DBI:mysql

2003-04-03 Thread Janek Schleicher
Jaws wrote at Thu, 03 Apr 2003 14:47:02 +0800: > I tried using the following: > > my $sth = $dbh->prepare(q{INSERT INTO MYTABLE (USERNAME,PASSWORD) VALUES (?, ?) > }) or die $dbh->errstr; > $sth->execute($username,PASSWORD('$pass')) or die $dbh->errstr; > $dbh->disconnect; >

DBI:mysql

2003-04-02 Thread jaws
hi all, i want to use the mysql password() function in my perl script. The function of my script is to insert values into mysql table. below is a snippet of mysq script: ### use DBI; $database="vpdn"; $host="localhost"; $user="db"; $pw="mysql";