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
