2012/08/04 23:14 -0400, Fred G
I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank
values become 0 when I define the datatype to be a DECIMAL (in our case
(DECIMAL(12,2)). Since there is the potential for values to be 0, this
poses a problem for us. I initially wanted to
Thanks for the response. I'm not sure that is exactly what is happening
for me.
I tried an example where I created a dummy database and a dummy table. If I
create a column with decimal datatype and insert 2 different rows, one
blank and one null, they both are treated as nulls. This is what I
...@gmail.com]
Sent: Monday, August 06, 2012 9:48 AM
To: Hassan Schroeder
Cc: mysql@lists.mysql.com
Subject: Re: DECIMAL datatype automatically makes blank become 0
Thanks for the response. I'm not sure that is exactly what is happening for me.
I tried an example where I created a dummy database
, Benjamin [mailto:bstill...@limitedbrands.com]
Sent: Monday, August 06, 2012 2:05 PM
To: 'Fred G'
Cc: mysql@lists.mysql.com
Subject: RE: DECIMAL datatype automatically makes blank become 0
I don't believe this is limited to Workbench. I saw the same behavior using
LOAD INFILE and a pipe-delimited
-
From: Fred G [mailto:bayespoker...@gmail.com]
Sent: Monday, August 06, 2012 9:48 AM
To: Hassan Schroeder
Cc: mysql@lists.mysql.com
Subject: Re: DECIMAL datatype automatically makes blank become 0
Thanks for the response. I'm not sure that is exactly what is happening
for me.
I tried
Hi--
I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank
values become 0 when I define the datatype to be a DECIMAL (in our case
(DECIMAL(12,2)). Since there is the potential for values to be 0, this
poses a problem for us. I initially wanted to make all the DECIMAL values
