title: How to insert a newline(\n) inside a String(text) into Cassandra by CQLSH command?
body: <p><strong>Update</strong>:
  Newline is working if I insert the same line by python driver script.</p>
  
  <p>session.execute("INSERT INTO  ctable"  + " (cid, cstring) VALUES (%s, %s)", <strong>('2', 'row1\nrow2')</strong>)</p>
  
  <p>Still don't understand why the CQLSH command doesn't work.</p>
  
  <p><strong>Original Question:</strong>
  I am trying to insert a very long string into Cassandra by CQLSH command, and add a '\n' to split the string into two lines when display.  </p>
  
  <p>I tried</p>
  
  <pre><code>insert into ctable (cid, cstring ) values('2', 'row1\nrow2');
  insert into ctable (cid, cstring ) values('2', 'row1\\nrow2');
  insert into ctable (cid, cstring ) values('2', 'row1\r\nrow2');
  </code></pre>
  
  <p>None of above statements worked, all <strong>\n</strong> had been treated as a regular chracter.
  Can anyone help?</p>