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.

What DB engine are you using? – juergen d Mar 14 '12 at 13:19 — juergen d, Mar 14 '12 at 13:19
mysql i guess, he said he is using phpmyadmin – rs. Mar 14 '12 at 13:23 — rs., Mar 14 '12 at 13:23

score 123 · Accepted Answer · answered Mar 14 '12 at 13:23

123

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)

answered Mar 14 '12 at 13:23

ypercubeᵀᴹ

113,259
19
174
235

score 6 · Answer 2 · answered Mar 14 '12 at 13:24

6

ALTER TABLE your_table
ADD PRIMARY KEY (Drugid);

answered Mar 14 '12 at 13:24

juergen d

201,996
37
293
362

score 4 · Answer 3 · answered Mar 14 '12 at 13:26

4

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

answered Mar 14 '12 at 13:26

Ortiga

8,455
5
42
71

score 3 · Answer 4 · edited Nov 07 '16 at 21:08

3

alter table table_name
add constraint myprimarykey primary key(column);

reference : http://www.w3schools.com/sql/sql_primarykey.asp

edited Nov 07 '16 at 21:08

Michał Powaga

22,561
8
51
62

answered Jul 04 '15 at 07:24

Ravi Kamesh

31
1

score 0 · Answer 5 · edited Mar 30 '20 at 10:15

0

Go to localhost/phpmyadmin and press enter key. Now select:

database --> table_name --->Structure --->Action  ---> Primary -->click on Primary

edited Mar 30 '20 at 10:15

frianH

7,295
6
20
45

answered Dec 08 '16 at 07:13

Cool Coder

3
4

SQL: set existing column as Primary Key in MySQL

5 Answers5

Linked