例子
UPDATE jibing set d_poetry=REPLACE(d_poetry ,CHAR(10),'<br/>')
UPDATE jibing set d_poetry=REPLACE(d_poetry ,CHAR(13),'<br/>')
CHAR(10)原始换行
CHAR(13)原始回车
例子
UPDATE jibing set d_poetry=REPLACE(d_poetry ,CHAR(10),'<br/>')
UPDATE jibing set d_poetry=REPLACE(d_poetry ,CHAR(13),'<br/>')
CHAR(10)原始换行
CHAR(13)原始回车