SQL set existing column as Primary Key in MySQL

Question

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

User · Answer

If you want to do it with phpmyadmin interface   Select the table -  Go to structure tab -  On the row corresponding to the column you want  click on the icon with a key

User · Answer

Go to localhost phpmyadmin and press enter key  Now select   database -- gt  table name --- gt Structure --- gt Action  --- gt  Primary -- gt click on Primary

User · Answer

ALTER TABLE your table ADD PRIMARY KEY  Drugid

User · Answer

Either run in SQL   ALTER TABLE tableName   ADD PRIMARY KEY  id            ---or Drugid  whichever you want it to be PK   or use the PHPMyAdmin interface  Table Structure

User · Answer

alter table table name add constraint myprimarykey primary key column     reference    http   www w3schools com sql sql primarykey asp

[mysql] SQL: set existing column as Primary Key in MySQL

Examples related to mysql

Examples related to sql

Examples related to indexing

Examples related to primary-key