Jump to content

Adding a Primary Key


zambotinii

Recommended Posts

I am using MySQL Front, and have created databases in the past.

 

However on this occasion I am having trouble creating a primary key. The MySQL Front program isnt giving me the option to make on of my columns a primary key and everytime I use the

 

ALTER TABLE table

ADD PRIMARY KEY (loginName);

 

command it reutrns an \"ERROR 1064\" message back.

 

Im sure Im logged in correctly but think this may eb the source of the problem! Any suggestions?

 

How would you make a field a PK in a table?

Link to comment
https://forums.phpfreaks.com/topic/330-adding-a-primary-key/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.