Mike,
set insert_id=1;
> can the auto_increment value be reset back to '1' withou recreate the
> entire table again ?? The table would be emptied first, but we would like
> to reset the auto_increment value back to '1' without having to drop and
> recreate the table, if possible.
Regards
Trevor Rhodes
===========================================
Powered by Linux - Mandrake 9.2
Registered Linux user # 290542 at http://counter.li.org
Registered Machine #'s 186951
Mandrake Club Silver Member
Source : my 100 % Microsoft-free personal computer.
===========================================
10:13:58 up 17:21, 1 user, load average: 1.42, 1.39, 1.22
--
Never mud wrestle with a pig.. you get dirty and the pig enjoys it!
Never try to teach a pig to dance. You waste your time and annoy the pig.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
