gusmacker Posted March 12, 2003 Share Posted March 12, 2003 I try to add a field to a existing database with phpmyAdmin and this is what I get SQL-query : ALTER TABLE `rbl` ADD `uniq` INT( 5 ) NOT NULL AUTO_INCREMENT FIRST MySQL said: Incorrect table definition; There can only be one auto column and it must be defined as a key Quote Link to comment https://forums.phpfreaks.com/topic/217-fields/ Share on other sites More sharing options...
metalblend Posted March 12, 2003 Share Posted March 12, 2003 It looks like you already have an auto_incriment field. Quote Link to comment https://forums.phpfreaks.com/topic/217-fields/#findComment-646 Share on other sites More sharing options...
gusmacker Posted March 12, 2003 Author Share Posted March 12, 2003 That is what I thought also but it only has 2 fields besides the one I am trying to add and neither is an auto inc field Quote Link to comment https://forums.phpfreaks.com/topic/217-fields/#findComment-647 Share on other sites More sharing options...
gusmacker Posted March 12, 2003 Author Share Posted March 12, 2003 I got it figured out. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/217-fields/#findComment-652 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.