I solved the problem, it was application problem.
but, Joseph, your method doesn't work
becos application is not continually logged in to the DB.
if the process is newly login, last_insert_id is 0
then the update will update the auto increment field to 0
becos select last_insert_id() returns 0.
ÅÇ´f¼Ù(Borus.Kung) a écrit :
>
> Hi all,
>
> I have a serious problem.
> I have a production system just launch using MySQL.
> auto increment field is used in the system by ASP, Visual Basic and C.
> System is using AIX 4.3.3, MySQL 3.23.49
> gcc 2.9 source code compiled MySQL
>
> There are so
