Well, according to the manual decimal type is defined as DECIMAL(M,D). M is the width not counting sign and decimals, and D is the number of decimal positions. D defaults to zero, and M to 10. try: cost DECIMAL(10,2) or whatever width you need.
Bryan Koschmann - GKT wrote:
My Apologies,
table name is pricelist with 2 colums: create table pricelist (product varchar(45), cost dec);
then
load data infile "/home/omni/OmniPrice.csv" into table pricelist fields terminated by ',';
the datafile looks like this
Jaton Modem,15.5 Teac Floppy,7.5 Celeron 1.7,54.5 Logitech KB,11
but a query returns this:
mysql> select * from pricelist; +-------------+------+ | product | cost | +-------------+------+ | Jaton Modem | 15 | | Teac Floppy | 7 | | Celeron 1.7 | 54 | | Logitech KB | 11 | +-------------+------+ 4 rows in set (0.00 sec)
I read the docs on the decimal type, but I dont quite understand it.
Thanks,
Bryan
On Fri, 21 Feb 2003, gerald_clark wrote:
|Show us. |We have no idea how you defined your tables, |loaded your data, or structured your query. | |Bryan Koschmann - GKT wrote: |
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php