Jump to content
MakeWebGames

Recommended Posts

Posted

I am trying to add a table into my database for donator houses...and I have successfully added the house ID, which I called the field dhID. But I am having trouble setting it to auto_increment. I get this error whenever I edit the structure of it:

SQL query:

ALTER TABLE `dhouses` CHANGE `dhID` `dhID` INT( 11 ) NOT NULL AUTO_INCREMENT

MySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

 

Any help/ideas?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...