#DECIMAL ( 5#TOTAL_DIGIT #, 2 #DIGITS AFTER DECIMAL)
#float -upto -7 digits, takes 4 bytes of memory
#double - upto - 15 digits , takes 8 bytes of memory
CREATE  table store (
   pro_id INT PRIMARY KEY  AUTO_INCREMENT,
    pro_name VARCHAR(50) NOT NULL,
    price DECIMAL(5,2) NOT NULL,
    tax float,
    ctax double
   
    
    
);
insert  into store (pro_id,pro_name, price, tax, ctax) values ( 101,"PENCIL",14.232,1233.245,134455.33333), (102,"SHARPERNER", 12.1,123.3456,1234567.987765555);
SELECT * FROM store;