cast(‘3.15926‘ as signed)
cast(浮点型 as signed)
MYSQL浮点型转int类型
原文：http://www.cnblogs.com/dengyg200891/p/6127053.html
