Jump to content


Photo

FIELDS


  • Please log in to reply
3 replies to this topic

#1 gusmacker

gusmacker
  • Members
  • Pip
  • Newbie
  • 9 posts
  • LocationGrand Rapids, Michigan

Posted 12 March 2003 - 02:20 AM

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


[php:1:09d88d0ab6]<? [br]if ($SKYDIVING == "NO") { [br]$LIFE = EMPTY; [br]} else { [br]$LIFE = "FULL OF JOY"; [br]?> [br][/php:1:09d88d0ab6]

#2 metalblend

metalblend
  • Members
  • PipPipPip
  • Advanced Member
  • 89 posts
  • LocationCalifornia, USA

Posted 12 March 2003 - 03:24 AM

It looks like you already have an auto_incriment field.

#3 gusmacker

gusmacker
  • Members
  • Pip
  • Newbie
  • 9 posts
  • LocationGrand Rapids, Michigan

Posted 12 March 2003 - 03:56 AM

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
[php:1:09d88d0ab6]<? [br]if ($SKYDIVING == "NO") { [br]$LIFE = EMPTY; [br]} else { [br]$LIFE = "FULL OF JOY"; [br]?> [br][/php:1:09d88d0ab6]

#4 gusmacker

gusmacker
  • Members
  • Pip
  • Newbie
  • 9 posts
  • LocationGrand Rapids, Michigan

Posted 12 March 2003 - 07:01 AM

I got it figured out. Thanks
[php:1:09d88d0ab6]<? [br]if ($SKYDIVING == "NO") { [br]$LIFE = EMPTY; [br]} else { [br]$LIFE = "FULL OF JOY"; [br]?> [br][/php:1:09d88d0ab6]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users