MySQL does not support casting as a double. Supported data types for Cast() are:
BINARY[(N)]
CHAR[(N)]
DATE
DATETIME
DECIMAL[(M[,D])]
SIGNED [INTEGER]
TIME
UNSIGNED [INTEGER]
转载于:https://www.cnblogs.com/pinnasky/archive/2012/06/13/2547716.html