Jump to content

Archived

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

zambotinii

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

 

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?

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.