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 Octavian Rasnita wrote: > Or more simple: > > ALTER TABLE tbl modify id INT UNSIGNED NOT NULL AUTO_INCREMENT; > > -- > Octavian > > ----- Original Message ----- From: "abdulazeez alugo" > <defati...@hotmail.com> > To: <jnaneshwar.banta...@kavach.net>; <mysql@lists.mysql.com> > Sent: Friday, April 10, 2009 1:07 PM > Subject: RE: auto_increment Issue > > > > > > >> Date: Fri, 10 Apr 2009 15:15:28 +0530 >> From: jnaneshwar.banta...@kavach.net >> To: mysql@lists.mysql.com >> Subject: auto_increment Issue >> >> >> Hi All >> >> I have created a table.Now I need to make a field Auto_increment...Help >> me with this issue..An example will do.. >> >> Regards >> 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. > > > _________________________________________________________________ > Show them the way! Add maps and directions to your party invites. > http://www.microsoft.com/windows/windowslive/products/events.aspx
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org