It is about If one can be allowed to update table.
If table colume has max value 100 and current value is 100 just one more
person can insert into table.
In case of this administrator should limit access other.
That's it..
Maybe use select query
>From: WANG_KING£¨Íõ¸Ö£© <[EMAIL PROTECTED]>
>To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
>Subject: test condition?
>Date: Fri, 23 Feb 2001 09:37:29 +0800
>
>In the section of "How to cope without commit/rollback" of mysql manual,
>it said
>1. Use LOCK TABLES ... to lock all the tables you want to access.
>2. Test conditions.
>3. Update if everything is okay.
>4. Use UNLOCK TABLES to release your locks.
>
>my question is what is Test conditions?and how to do?
>
>Yours,
>Sincerely
>King Wang
>Shanghai Huateng Software Systems Co, Ltd.
>8/F, Wenxin United Press Tower, 755 Wei Hai Road, Shanghai 200041, P.R.C
>PH:32014500-5106
>Email:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
>
>
>---------------------------------------------------------------------
>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
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
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
