How to get float values from sql query

Manohar Thunga

2018 9 16

0 个回答

1 次查看（30 天）

0 个投票

I have following table

        d       dd
      ______    __
      12.345    12
      34.567    34
      45.678    45
  ss = fetch(conn,'SELECT d FROM sc WHERE dd = 12')

when I execute above query, I am getting correct result as

       d   
    ______
    12.345

but following query giving the wrong answer as an empty table

ss = fetch(conn,'SELECT d FROM sc WHERE d = 12.345')

How to resolve this issue

4 个评论
显示 2更早的评论隐藏 2更早的评论

Ming Yue 2018-9-19

在 MATLAB Online 中打开

Hi Manohar,

What version of MATLAB, what database and which version of connector are you using? I think the issue could be platform dependent.

I tested the above scenario on MATLAB R2018a with MySQL 8.0 and ODBC connector 5.3. Here's what I got:

>> ss = fetch(conn,'SELECT d FROM sc WHERE dd = 12')

ss =

1×1 cell array
    {[12.3450]}

>> ss = fetch(conn,'SELECT d FROM sc WHERE d = 12.345')

ss =

1×1 cell array
    {[12.3450]}

>> ss = fetch(conn,'SELECT d FROM sc WHERE d = 12.3456')

ss =

[]

Walter Roberson 2018-9-19

My suspicion is that the data stored is not bit-for-bit identical to however sql translates decimal 12.345 (keeping in mind it is being transferred as text for the purposes of the query). I think the stored 12.345-ish value might be truncated due to printing limitations.

That is why I recommend pulling back whatever is there and subtract 12.345 to see what the difference is

请先登录，再进行评论。

请先登录，再回答此问题。

Follow Question