6 messages in com.mysql.lists.win32DataType Question
FromSent OnAttachments
Melissa Dougherty14 Jun 2006 06:28 
Melissa Dougherty14 Jun 2006 07:24 
Armando14 Jun 2006 17:22 
Melissa Dougherty14 Jun 2006 18:40 
Petr Vileta14 Jun 2006 20:22 
Helen M Hudson14 Jun 2006 23:21 
Subject:DataType Question
From:Melissa Dougherty (meli@cse-corp.com)
Date:06/14/2006 06:28:45 AM
List:com.mysql.lists.win32

I'm importing data into MySQL from a CVS file.... one column has dollar amounts.
There are negative numbers like this... (999.99). Is there a way to get the
database to convert this into.... -999.99? And what is the best datatype to
choose?

Thanks,

Melissa