title: MySQL Database Unique Column Names
body: <p>I have written myself a PHP script to help manage a small squad of 10 members. This script current connects to a database and updates weekly updating any rank and power change. However I want to expand this and in a new table, have all the power gained kept in a separate column instead of adding it all up.</p>
  
  <p>The only way I can think of doing this is by using the below code to create the column and changing the name for each.</p>
  
  <pre><code>ALTER TABLE `power gained` ADD timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER name;
  </code></pre>
  
  <p>So my question is, can I create columns making sure their name is unique, OR is it possible to set a column name to the timestamp as that would save me a column.</p>
  
  <p>I'd like to also make it clear I am using mysql_ functions as this is on my local system, not vulnerable to attacks and I am not stupid enough to make mistakes.</p>