decimal values is rounded
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 |
|