decimal data type
Posted by: greta-girl (---.sip.aby.bellsouth.net)
Date: May 13, 2017 08:26AM

Hi everyone. This is my 1st attempt with WAMP. I'm trying to set-up a table where 3 of the fields are decimal numbers. I created them as decimal(6,2) data type. When I save the table it displays as decimal(6,0). What am I doing wrong? Any help is appreciated.

Options: ReplyQuote
Re: decimal data type
Posted by: RiggsFolly (Moderator)
Date: May 13, 2017 01:48PM

Hi,

This is not a WAMPServer issue. Have a look at the MySQL manual, a link is available in my signature block.
Or look at the manual for phpMyAdmin to see what you are doing wrong

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: decimal data type
Posted by: greta-girl (---.sip.aby.bellsouth.net)
Date: May 16, 2017 02:03AM

This had worked before in a non-WAMP environment, so I thought it was WAMP. Thanks RiggsFolly. I will check the MySQL link.

Options: ReplyQuote


Sorry, only registered users may post in this forum.