SELECT CAST( 1.23456789 AS DECIMAL( 7,5 ) ) as col;
CREATE VIEW foo AS SELECT CAST( 1.23456789 AS DECIMAL( 7,5 ) ) AS col;
SELECT * FROM foo;
DESC foo;
SHOW CREATE VIEW foo;