content_image/742412.jpg
mysql> INSERT INTO t VALUES(1,1,1); mysql> CREATE TABLE y SELECT AVG(i), AVG(d), AVG(f) FROM t; 

The result is a double only for the floating-point argument. For exact type arguments, the result is also an exact type: 

<img src='content_image/742412.jpg'>

The result is a double only for the floating-point argument. For exact type arguments, the result is also an exact type. 

