car.3205 发表于 2018-10-7 08:03:57

mysql插入换行符

  UPDATE aws_system_setting SET value='s:50:"广告/SPAM\n违规内容\n文不对题\n重复发问";' where varname="report_reason"; ````
  查询:
  mysql> select * from aws_system_settingwhere varname="report_reason";
  +----+---------------+------------------------------------------------------------+

  |>  +----+---------------+------------------------------------------------------------+
  | 77 | report_reason | s:50:"广告/SPAM
  违规内容
  文不对题
  重复发问";               |
  +----+---------------+------------------------------------------------------------+
  1 row in set (0.01 sec)

页: [1]
查看完整版本: mysql插入换行符