I don't think you need to know DBD::mysql (DBD::mysql is a DBD driver to mysql). Go and have a look at the man page of DBI. You'll get what you need.
Andy Cheng wrote: > > Thanks for the help. I got it working. I could connect to mysql from shell > command. Now I try to connect to mysql using perl. I installed the DBI::DBD > module for perl. I think the DBI::DBD also working since I don't see error > return running the following code: > > #!/usr/bin/perl > > use DBI; > $dbh=DBI->connect('DBI:mysql:andy'); > my $query="select * from client"; > my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n"; > $sth->execute; > my $rows; > while(@row=$sth->fetchrow_array) > {my $i; > for $i (0..($sth->{num_of_fields}-1)) > {print "[".$row[$i]."]";} > print("\n"); > } > $sth->finish; > $dbh->disconnect > > I don't understand the code. I copy it from a book. I am trying to print out > the records returned from a query. I have a table named client in database > andy. The table has 2 records. When I run the above code, I have 2 blank > lines return. Could any one tell me what the problem is? Where could I > find better documentation on DBI::DBD::mysql stuff for beginner? man > DBD::mysql is difficult to understand. Thanks again for the info. > > >From: "Chuck \"PUP\" Payne" <[EMAIL PROTECTED]> > >To: Doug Thompson <[EMAIL PROTECTED]>, Andy Cheng > ><[EMAIL PROTECTED]>, Intrex <[EMAIL PROTECTED]>, > >"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > >Subject: Re: Mysql installation. Help! > >Date: Sun, 10 Mar 2002 14:18:13 -0500 > > > >Ok, if never run it then you have to start once, if I remember right undex > >Red Hat, you have to go to /etc/rc.d/init.d and do this... > > > >./mysql start that will start it > > > >Then you will need to set it up so it will start later. SuSE you have to > >start it once.... > > > >You will then need to set a password for mysql. > > > >I hope that helps. > > > > > > ---------------------------- > > | Chuck Payne | > > | Magi Design and Support | > > | www.magidesign.com | > > | [EMAIL PROTECTED] | > > ---------------------------- > > > >BeOS, Macintosh 68K, Classic, and OS X, Linux Support. > >Web Design you can afford. > > > >Fortune for today -- > > > >Q: How many Zen masters does it take to screw in a light bulb? > >A: None. The Universe spins the bulb, and the Zen master stays out > > of the way. > > > > > > > > > If mysql.sock doesn't exist, that is because the server is not running. > > > > > > I fought the same battle as Mark and ultimately downloaded and installed > >the > > > RPM for 3.23.49a from MySQL in place of > > > the copy that came with RH. The MySQL RPM installed and came up just > >like it > > > says in the book. Saves a lot of hair > > > and dain bramage. > > > > > > If the server process _is_ running, it may be useful to go through the > >section > > > on binary installation and check those > > > items to see if your RPM set everything up correctly. Don't bet on > >finding > > > anything, but it doesn't take long to do > > > these checks. > > > http://www.mysql.com/doc/I/n/Installing_binary.html > > > > > > Regards, > > > Doug > > > > > > "Perfection is finally attained not when there is no longer anything to > >add, > > > but when there is no longer anything to > > > take away." -- Antoine de Saint Exup?ry > > > > > > On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote: > > > > > >> What I did was beat my brains out on the same exact problem. In the > >end I > > >> have no clue what I did to get it actually working. I had re-installed > >the > > >> mysql from the .tar.gz, I installed all the RPM's several times. > >Everytime, > > >> I fully rebooted the system, and finally I have to run > > >> safe_mysqld --user=root > > >> > > >> I think finaly I ran the tar -zxvf on the mysqlmax.<version>.tar.gz, > > >> rebooted the system, then re-ran safe_mysqld --user=root. > > >> > > >> Mark > > >> > > >> ----- Original Message ----- > > >> From: "Andy Cheng" <[EMAIL PROTECTED]> > > >> To: <[EMAIL PROTECTED]> > > >> Sent: Sunday, March 10, 2002 10:01 AM > > >> Subject: Mysql installation. Help! > > >> > > >> > > >>> Hi all, > > >>> I got this error message when trying to connect to mysql at the shell > > >>> command: > > >>> > > >>> Error 2002:Can't connect to local MySql server through socket > > >>> '/var/lib/mysql/mysql.sock > > >>> > > >>> > > >>> There is no mysql.sock in the /var/lib/mysql directory. Did I miss > >some > > >>> thing in the mysql installation? Where could I find the mysql.sock? > >I > > >>> install mysql that came with redhat 7.2. Thank for the help. > > >>> > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > _________________________________________________________________ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php