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 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

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.