Jump to content
Updating IPB tonight Read more... ×


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


Adding a Primary Key

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



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?

Share this post

Link to post
Share on other sites


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.