DataType Question

"Melissa Dougherty" <[email protected]> Wed, 14 Jun 2006 09:29:08 -0400

Newsgroups	gmane.comp.db.mysql.windows
Message-ID	<000601c68fb6$84227b70$6400a8c0@denterprise1>

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

lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.