Hi, I am trying to find how to use command "select count(*)". I tried it in mysql query console, it shows the number of my rows in my table. But when I tried it in perl with $sth->do("select count(*) from mytable") and run the perl script from DOS console, I always gets "1" in value. What is the right way to do it in order to get the number of rows in my table in return? I am looking forward to a favorable reply from you. Thank you.
Regards, Eko Budiharto.