MySQL Forums
Forum List  »  MySQL Workbench

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Alternatives to specifying number of digits for floating types
199
C D
July 08, 2020 06:56PM


Sorry, only registered users may post in this forum.

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.