我正试图做到这一点:
SELECT CAST(columnName AS INT), moreColumns, etc
FROM myTable
WHERE ...
我已经看了这里的帮助常见问题:http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html,它说我可以像CAST(val AS TYPE)
一样做,但它不起作用.
try 将十进制数转换为int,实际值是223.00,我想要223
我正试图做到这一点:
SELECT CAST(columnName AS INT), moreColumns, etc
FROM myTable
WHERE ...
我已经看了这里的帮助常见问题:http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html,它说我可以像CAST(val AS TYPE)
一样做,但它不起作用.
try 将十进制数转换为int,实际值是223.00,我想要223