Mysql 字符串指定位置插入空格

UPDATE flow_data_243 SET data_15=CONCAT(LEFT(data_15,10),' ',RIGHT(data_15,LENGTH(data_15)-10)) WHERE CHAR_LENGTH(data_15)=18;

posted @ 2019-02-12 14:39  limitpjz  阅读(2615)  评论(0编辑  收藏  举报