Re: select decimal column from mysql

2021-12-19 Thread john miky
sorry, please ignore this stupid question, 0.015 is > 0 On Mon, Dec 20, 2021 at 2:19 PM john miky wrote: > hmm. it is perl's "problem", not dbi. > > On Mon, Dec 20, 2021 at 1:20 PM john miky wrote: > >> hi, >> >> I select a decimal column, from mys

Re: select decimal column from mysql

2021-12-19 Thread john miky
hmm. it is perl's "problem", not dbi. On Mon, Dec 20, 2021 at 1:20 PM john miky wrote: > hi, > > I select a decimal column, from mysql with dbi, > the value 0.015 for example, my ($v) = $dbh->selectrow_array("select > price from test limit 1") >

select decimal column from mysql

2021-12-19 Thread john miky
hi, I select a decimal column, from mysql with dbi, the value 0.015 for example, my ($v) = $dbh->selectrow_array("select price from test limit 1") it is greater than 0 in perl. What's the proper way to get a float value ?