Just in case you need it:
alter table yourtable
change ID ID auto_increment primary key not null; describe yourtable;
That should do it!
>You need to manually set these to the MySQL autoincrement type (can't
>remember the exact descriptor, sorry.. can find it if required).
> (a windows MySQL
>admin tool) if you havn't already.
>
>------------------------------------
>Broadband Communications Ltd.
>+44 (0)115 924 7150
>http://www.broadband.co.uk/
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.