title: Simple way to duplicate a record in Navicat
body: <p>The natural instinct would be to copy/paste the entire row as one would do in MS Excel or other spreadsheet app.</p>
  
  <p>But:</p>
  
  <ol>
  <li>Unique primary key / UNIQUE INDEX fields cannot be duplicated.</li>
  <li>If one of the fields has line breaks in it (e.g. a chunk of HTML code) it attempts to create multiple new records instead.</li>
  </ol>
  
  <p>The first issue can be relatively quickly worked around by temporarily turning the indexes off. However, #2 is a pain in the neck. Any ideas anyone?</p>
  
  <p>Of course I could <a href="https://stackoverflow.com/questions/9670731/quickest-way-to-duplicate-a-mysql-record">use a query</a>. But the question is about Navicat’s GUI.</p>
  
  <p>Also in case it matters, I use Navicat for MySQL v9.0.8 Enterprise.</p>