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