It is just a string.
It does not lock anything in the database.
It sets a semaphore to be tested by other programs.
You need to make sure ALL programs updating your database use
the string locks, and that the stringlock will be unique for every
record.
you could youse something like database-table-primarykey.
Randy Johnson wrote:
>
> When using getlock what goes in the str in the following syntax
>
> GET_LOCK(str,timeout)
>
> is the the primary key of the row that you would like to lock? the manual isn't
>very specific on that....
>
> Thanks
>
> randy
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
