| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|Help Adding An Auto Increment Column into a table|
Might be phpmyadmin, mysql version problem.
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:
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 - 18.104.22.168 & MySQL client version: 5.0.20.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved