> Date: Fri, 10 Apr 2009 15:55:33 +0530
> From: jnaneshwar.banta...@kavach.net
> To: orasn...@gmail.com
> CC: defati...@hotmail.com; mysql@lists.mysql.com
> Subject: Re: auto_increment Issue
>
> Hi
>
> While trying for the same,I am getting the following error
>
> Incorrect table definition; there can be only one auto column and it
> must be defined as a key
>
> Jnani
>
> >
> > Hi Jnani,
> >
> > Assuming your table name is tbl and the field for the auto_increment is
> > id, just write:
> >
> >
> >
> > ALTER TABLE tbl CHANGE id id INT UNSIGNED NOT NULL AUTO_INCREMENT;
> >
> >
> >
> > I hope that helps.
> >
> > Cheers.
> >
> >
> >
> > Alugo Abdulazeez.
> >
Oh sorry!
it should be ALTER TABLE tbl CHANGE id id INT UNSIGNED NOT NULL PRIMARY KEY
AUTO_INCREMENT;
I hope this helps unless you have a column already defined as auto_increment in
the same table.
Cheers.
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx