update table_name set col_name = replace(col_name,'\n','')
update table_name set col_name = replace(col_name,' ','')
資料庫中針對carchar 排列
select * from XXX ORDER BY CAST(`A` AS DECIMAL(10,2)) DESC;
文章標籤
全站熱搜
- 9月 22 週四 201114:08
在mysql中直接去除空白或是行
update table_name set col_name = replace(col_name,'\n','')
update table_name set col_name = replace(col_name,' ','')
資料庫中針對carchar 排列
select * from XXX ORDER BY CAST(`A` AS DECIMAL(10,2)) DESC;