Re: MYSQL Auto-Increment Field increment by itself

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.

MYSQL Auto-Increment Field increment by itself

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 some C compiled process using auto increment field

Re: MYSQL Auto-Increment Field increment by itself

ÅÇ´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 some C