Advertisement
ioggstream

Untitled

Apr 30th, 2018
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. mysql> select * from t1;
  2. +------+------+
  3. | c | d |
  4. +------+------+
  5. | 0.10 | 0.1 |
  6. | 0.20 | 0.2 |
  7. +------+------+
  8. 2 rows in set (0,00 sec)
  9.  
  10. mysql> select sum(c) as decimal_, sum(d) as double_ from t1;
  11. +----------+---------------------+
  12. | decimal_ | double_ |
  13. +----------+---------------------+
  14. | 0.30 | 0.30000000000000004 |
  15. +----------+---------------------+
  16. 1 row in set (0,00 sec)
  17.  
  18. mysql> desc t1;
  19. +-------+--------------+------+-----+---------+-------+
  20. | Field | Type | Null | Key | Default | Extra |
  21. +-------+--------------+------+-----+---------+-------+
  22. | c | decimal(2,2) | YES | | NULL | |
  23. | d | double | YES | | NULL | |
  24. +-------+--------------+------+-----+---------+-------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement