title: how to set unique primary key for all table in same database
body: <p>how to set an unique primary key to all the table of database?<br>
  for example i don't wanted to repeat any primary key of different table.</p>
  
  <pre><code>table A:
  ----------
  id | name
  ----------
  1  | aaa
  3  | bbb
  5  | ccc
  
  table B:
  -------------
  id | surname
  -------------
  7  | ddd
  2  | eee
  9  | fff
  
  table C:
  -------------
  id | nickname
  -------------
  4  | ggg
  6  | hhh
  8  | iii
  </code></pre>
  
  <p>all <code>id</code> are <code>primary key</code> and <code>auto_increment</code>.
  All the data is entered dynamically.I am using <code>MYSQL</code> in <code>PHPMYADMIN</code>. </p>