Bug #12664 | Format(X,D) function doesn't allow Table's Field as Parameter | ||
---|---|---|---|
Submitted: | 19 Aug 2005 4:31 | Modified: | 10 Oct 2019 21:40 |
Reporter: | RaguNathan T | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S4 (Feature request) |
Version: | 5.0.7-beta-pro-nt | OS: | Windows (WIndows XP) |
Assigned to: | CPU Architecture: | Any |
[19 Aug 2005 4:31]
RaguNathan T
[20 Aug 2005 7:11]
RaguNathan T
This will help if you are doing multiple type of products. Example is "TShirts" will go by Pieces. They will not use the decimals. But "Chemicals","Yarn" will use the Decimals. so the format() will play a vital role here. I'm looking for this function for my report.
[28 Apr 2008 17:32]
Sveta Smirnova
Thank you for the reasonable feature request. select format(field, @foo) doesn't work either.
[30 Sep 2008 14:24]
Konstantin Osipov
WL#3809 Add expressions where possible, e.g. in LIMIT
[16 Oct 2008 9:18]
Sveta Smirnova
Bug #40071 was marked as duplicate of this one.
[10 Oct 2019 21:40]
Roy Lyseng
Posted by developer: Implemented in 5.7 (or earlier)