Escape line breaks in MySQL output

by 
SELECT REPLACE(
    REPLACE(yourcolumn, '\r', '\\r'),
    '\n',
    '\\n'
) FROM yourtable;

More Related Contents:

  1. Out of memory Microsoft VBScript runtime error 800a0007
  2. MySQL how to fill missing dates in range?
  3. Left Outer Join doesn’t return all rows from my left table?
  4. How can i optimize MySQL’s ORDER BY RAND() function?
  5. Are table names in MySQL case sensitive?
  6. How to split the name string in mysql?
  7. Get table names using SELECT statement in MySQL
  8. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  9. Can a foreign key reference a non-unique index?
  10. Storing Data in MySQL as JSON
  11. How to set a maximum execution time for a mysql query?
  12. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  13. SQL keys, MUL vs PRI vs UNI
  14. Can’t Create Entity Data Model – using MySql and EF6
  15. How to copy a row and insert in same table with a autoincrement field in MySQL?
  16. How does a MYSQL Self-Join Work?
  17. How to move columns in a MySQL table?
  18. access denied for load data infile in MySQL
  19. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  20. What is the best MySQL collation for German language
  21. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  22. quick selection of a random row from a large table in mysql
  23. How can we find gaps in sequential numbering in MySQL?
  24. Optimization of MySQL search using “like” and wildcards
  25. NodeJS MySQL Dump
  26. Why do I need “OR NULL” in MySQL when counting rows with a condition
  27. Find date range overlaps within the same table, for specific user MySQL
  28. MySQL on delete cascade. Test Example
  29. Return Last ID (IDENTITY) On Insert row VB.NET MySQL
  30. Database Historization

Leave a Comment