CREATE TABLE test (id INTEGER,qu DECIMAL(10, 2),price DECIMAL(5, 2),total DECIMAL (10, 2)); data:3 27.1 56.7 || 2 23.7 22.8 ||1 12.5 25.6 update test set total = price * qu; id 3 total display 1536.5700000000002, sql error? field definition error? new one,pls give me a hand, 3Q!