When you don't specify the precision for a DECIMAL column, it is assumed to be 0. This is documented in the previously posted link.
create table pricelist (product varchar(45), cost dec(18, 2)) HTH, Tore. ----- Original Message ----- From: "Bryan Koschmann - GKT" <[EMAIL PROTECTED]> To: "gerald_clark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 4:00 PM Subject: Re: decimal type > 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
