Re: auto_increment Issue

2009-04-10 Thread Jnaneshwar Bantanur
Hi , Thanks,Its working now Jnani abdulazeez alugo wrote: > > > >> 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

Re: auto_increment Issue

2009-04-10 Thread Jnaneshwar Bantanur
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 >

auto_increment Issue

2009-04-10 Thread Jnaneshwar Bantanur
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org