krasatos krasatos - 1 year ago 83
MySQL Question

SQL: set existing column as Primary Key in MySQL

I have a database with 3 columns:

id, name, somethingelse

This table has no index set and i am getting "No index defined!" in phpmyadmin

id is a 7digit alphanumeric value, unique to each row.

I want to set Drugid to be the primarykey/index (i dont know the difference if there is one)

Please explain in detail as i am new to this.

Thank you.

Answer Source

Either run in SQL:

  ADD PRIMARY KEY (id)           ---or Drugid, whichever you want it to be PK

or use the PHPMyAdmin interface (Table Structure)

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download