Alternatives to specifying number of digits for floating types
Posted by:
C D
Date: July 08, 2020 06:56PM
I'm using a MySQL 8.0 installation on Ubuntu 18.04 accessed within Workbench 6.3.
I've created several tables where I use the nonstandard M and D parameters for a column of type DOUBLE, in this case all columns are of type DOUBLE(22,8).
Any time I query the table I get a warning indicating specifying number of digits is deprecated and will be removed.
(1) Aside from simply turning off warning notifications, is there a way to silence this message from being returned every time I query the tables in question?
(2) What is the general guidance for nonstandard situations where creating tables with columns where, number of decimals represented, for instance, is meaningful?
Subject
Views
Written By
Posted
Alternatives to specifying number of digits for floating types
814
July 08, 2020 06:56PM
332
July 08, 2020 08:20PM
347
July 08, 2020 08:30PM
302
July 09, 2020 09:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.