select * from t_order_pay as t where t.ORDER_ID = "P2112080905260030" and cast(TRADE_AMOUNT as UNSIGNED INTEGER) >0
sql中把String类型转为INTEGER类型
最新推荐文章于 2024-07-21 03:11:36 发布
select * from t_order_pay as t where t.ORDER_ID = "P2112080905260030" and cast(TRADE_AMOUNT as UNSIGNED INTEGER) >0