I have a table that I got deleted. I remade the table and populated it by hand, but to add new data I need one of the fields to be an auto_increment field how do I set that field to auto_increment since it now has data in it that I need to keep those values.

describe MY_categories;
+-------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+----------------+
| cat_id | int(4) | | PRI | NULL | auto_increment |
| parent_id | int(4) | YES | | NULL | |

I need the cat_id to be made to auto_increment, but I do have numbers in that field allready (the ones I had to add by hand).

__________________
Mitch

ALTER TABLE table_name AUTO_INCREMENT = 60;

Just fill in the number for the last highest integer.

From the MySQL manual:
  http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html

: )
Rich

::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::