title: MySQL Views in Navicat - How to define 'primary key'?
body: <p>Often when I define a View in Navicat I receive the following message:</p>
  
  <blockquote>
    <p>xxx does not have a primary key. Updates to this table will be done using the following pseudo statement: UPDATE xxx SET ModifiedFieldsAndValues WHERE AllFieldsAndOldValues LIMIT 1</p>
  </blockquote>
  
  <p>Obviously I only use my Views for <strong>viewing</strong> data, not <strong>updating</strong>. But this did make me curious:  </p>
  
  <p><strong>Is there a way to define a "primary key" or "unique index" on a View?</strong></p>