> 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