Welcome to WebmasterWorld Guest from 54.196.110.18

Forum Moderators: open

Message Too Old, No Replies

Help Adding An Auto Increment Column into a table

Might be phpmyadmin, mysql version problem.

     
6:58 pm on Feb 8, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 30, 2004
posts:1148
votes: 0


Hey All,

Need a little help - I have done this several times with no problems however when I updated my computer I am now getting errors.

I have a table with values Town,Region I now wish to add in an Auto_Increment column into this table. I use id, int 11, not null, auto_increment & select Primary Key. I click save and get this error:


SQL query:

ALTER TABLE `cities` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT FIRST

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

I am using: phpMyAdmin - 2.11.3 & MySQL client version: 5.0.51

It works fine on: phpMyAdmin - 2.8.0.3 & MySQL client version: 5.0.20.

Any ideas?

10:57 pm on Feb 8, 2008 (gmt 0)

New User

10+ Year Member

joined:May 13, 2007
posts: 26
votes: 0


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

That's the problem. Only one column may be auto_increment. Is there any particular reason you need two? Generally, auto_increment is just used to generate unique id's for each row.

11:12 pm on Feb 8, 2008 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
posts:5663
votes: 76


Also see [webmasterworld.com...]
1:08 am on Feb 9, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 30, 2004
posts:1148
votes: 0


Thanks yumigator & LifeInAsia,

I just double checked but there is no other primary field & also says in phpmyadmin "No index defined!" I am sure there is no auto_increment.

I can do all of this in the previous version of phpmyadmin/mysql however when I updated it started giving me this error, so any help?

RJ

3:53 pm on Feb 9, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Nov 28, 2004
posts:7999
votes: 0


alter table cities add id int(11) primary key auto_increment not null;
4:16 pm on Feb 9, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 30, 2004
posts:1148
votes: 0


Hi rocknbil,

You are my hero. One question I have is why did it not add that into the mysql statement even when I clicked the "primary key" checkbox in phpmyadmin?

Thanks - It works!

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members