trouble with perl

2012-08-06 Thread Elim Qiu
To populate table for a perl forum, I got the following error: aMac:mwf elim$ perl install.pl dyld: lazy symbol binding failed: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace dyld: Symbol n

Re: DECIMAL datatype automatically makes blank become 0

2012-08-06 Thread Fred G
Thanks! I'll create a temp table to handle it as well. On Mon, Aug 6, 2012 at 2:13 PM, Stillman, Benjamin < bstill...@limitedbrands.com> wrote: > Meant to add: > > My workaround was to set the column as varchar then convert it to decimal > after the import. When adding to the table, I use a temp

RE: DECIMAL datatype automatically makes blank become 0

2012-08-06 Thread Stillman, Benjamin
Meant to add: My workaround was to set the column as varchar then convert it to decimal after the import. When adding to the table, I use a temp table to import to as varchar, convert the column, the just select from temp table into prod table. -Original Message- From: Stillman, Benj

RE: DECIMAL datatype automatically makes blank become 0

2012-08-06 Thread Stillman, Benjamin
I don't believe this is limited to Workbench. I saw the same behavior using LOAD INFILE and a pipe-delimited file. There's a bug report that's been open since November of 2006 about this: http://bugs.mysql.com/bug.php?id=23212 -Original Message- From: Fred G [mailto:bayespoker...@gmail.

Re: DECIMAL datatype automatically makes blank become 0

2012-08-06 Thread Fred G
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 wo