mysql>  DESCRIBE y; +--------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+---------------+------+-----+---------+-------+ | AVG(i) | decimal(14,4) | YES | | NULL | | | AVG(d) | decimal(14,4) | YES | | NULL | | | AVG(f) | double | YES | | NULL | | +--------+---------------+------+-----+---------+-------+ mysql>  INSERT INTO t VALUES(1,1,1); mysql>  CREATE TABLE y SELECT AVG(i), AVG(d), AVG(f) FROM t; Precision Math Examples The result is a double only for the floating-point argument. For exact type arguments, the result is also an exact type: The result is a double only for the floating-point argument. For exact type arguments, the result is also an exact type. 2462