title: Mysql string input with formatting
body: <p>I am a beginner at MySQL and I am having a little trouble with the correct formatting for a cell in my table. </p>
  
  <p>I have the data type set to <code>TEXT</code> so there is plenty of space for a few small paragraphs within the cell however my problem is, how do I format the paragraph with apostrophes, quotes, colons, and other punctuation that I am inserting into that cell via command line (MAC)? </p>
  
  <p>This is what the column values are: </p>
  
  <pre><code>joke TEXT NOT NULL,
  </code></pre>
  
  <p>I want to insert this example joke into the table: </p>
  
  <pre><code>Husband says: "When I'm gone you'll never find another man like me".
  Wife replied: "What makes you think I'd want another man like you!"
  </code></pre>
  
  <p>How do I write it into command line so it will display the exact formatting or at least something close. My command line entry looks like this:</p>
  
  <pre><code>INSERT INTO jokes
  (date_submitted, source, joke_style, joke)
  VALUES
  (NOW(), 'www.example.com','Blonde', 'Joke would go here with (: ' ,) and so on.');
  </code></pre>
  
  <p>Do I escape the apostrophes with <code>\'</code>? What do I do with the rest of the punctuation, and how do I store line breaks? </p>