Simultaneous accesses to the same table. How to avoid conflicts?

Hello,

I have just began to use MySQL server. I would like to run the server
on system A and be able to connect simultaneously to the SAME table from
multiple other systems (maximum 5). These clients could access the same row
and column of the table. One of the row is a counter. Each time a client
accesses the table it does the following queries:
1) read the curent value of counter;
2) update the value of counter (ie +1)

How can I prevent conflicts between the clients? Is there a mechanism in
MySQL server? Or do I need to use the multithread library of MSVC++ 6.0
(mutex)?

Thank you!

P. Lalonde,
Canada,
lepascal01@yahoo.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org