01 2024 档案

mysql修改json字段sql备份
摘要：update dec_main a, dec_main_copy20240110 b set a.ie_Date = b.ie_Date, a.declaration_data = b.declaration_data, a.custom_state = b.custom_state, a.cont 阅读全文
posted @ 2024-01-11 10:18 薛柏梁 阅读(24) 评论(0) 推荐(0) 编辑
查询sql保留小数去除小数点后面多余的0
摘要：select TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM ROUND(sum(FIRM_QTY),5))) resfirmQty from ldc_stock 阅读全文
posted @ 2024-01-08 17:42 薛柏梁 阅读(286) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示