RE: change field to auto increment

2005-06-01 Thread Reinhart Viane
, Reinhart Viane Btw, how do you show your tables layout like you did in this mail? -Oorspronkelijk bericht- Van: Michael Stassen [mailto:[EMAIL PROTECTED] Verzonden: woensdag 1 juni 2005 16:47 Aan: [EMAIL PROTECTED] CC: mysql@lists.mysql.com Onderwerp: Re: change field to auto increment

Re: change field to auto increment

2005-06-01 Thread Michael Stassen
Reinhart Viane wrote: Hey list, I need a query that checks if a certain table column has type auto-increment If not set it to auto increment, else do nothing. Let's say I have the table objects (object_id, object_name) in which object_id is the primary field. Now check to see if object_id is

change field to auto increment

2005-06-01 Thread Reinhart Viane
Hey list, I need a query that checks if a certain table column has type auto-increment If not set it to auto increment, else do nothing. Let's say I have the table objects (object_id, object_name) in which object_id is the primary field. Now check to see if object_id is auto_increment a