i have create the mysql table as below. My problem is with the prod_price.
i enter the price as decimal but the value i get when i retrieve it is the rounded value of what i have entered.
1. Could someone tell me why?
2. How am i going to make the sql to stored the values?
    (as entered because i need it to do calculation using the exact value)

CREATE TABLE PRODUCT
(
    PROD_ID VARCHAR(5) NOT NULL,
    PROD_NAME VARCHAR(20) NOT NULL,
    PROD_DESC VARCHAR(20) NOT NULL,
    PROD_PRICE DECIMAL(6,2) NOT NULL,
    PROD_BRAND INT NOT NULL,
    PRIMARY KEY(PROD_ID),
    FOREIGN KEY(PROD_BRAND) REFERENCES BRAND,
);

INSERT INTO PRODUCT VALUES('H001', 'THOMPSON', 'ACTIVATED GINGKO EXTRACT', 92.80, 1);
INSERT INTO PRODUCT VALUES('H002', 'SUPRADYN', 'MULTIVITAMIN PREPARATION', 68.90, 1);
INSERT INTO PRODUCT VALUES('H003', 'BIOGROW', 'GINGKO PHYTOSOME', 49.60, 1);

mysql> select prod_id, prod_price from product
+---------+------------+
| prod_id | prod_price |
+---------+------------+
| H001 | 93.00 |
| H002 | 69.00 |
| H003 | 50.00 |

I'm looking through the MySQL manual and I'm not immediately seeing what could be wrong there.

What I can deduce from the manual which says the following:

..since they are stored as strings perhaps you must enclose the value in quotes in order to get the database to preserve precision values.

I haven't tested it out myself. Give that a go and see if it makes a difference.

: )
Rich

:::::::::::::::::::::::::::::::::
Smiling Souls
http://www.smilingsouls.net
:::::::::::::::::::::::::::::::::

thanks! i finally found out what happen.After i drop the product table and then create and insert value into the table, everything is fine. Maybe because at first i create the prod_price decimal then i modify it to become decimal(8,2) so there's a error. When i then recreate the table with prod_price decimal(8,2), it works fine.