The Ace Posted April 19, 2008 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
The Ace Posted April 19, 2008 Author Posted April 19, 2008 Re: Humph...help please! I have found it out myself! lol. :) Quote
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.