The Ace Posted April 19, 2008 Share Posted April 19, 2008 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? Quote Link to comment Share on other sites More sharing options...
The Ace Posted April 19, 2008 Author Share Posted April 19, 2008 Re: Humph...help please! I have found it out myself! lol. :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.