Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Restrict selecting from a table
October 5, 2005, 6:45 am
rate this thread
Is there a way to restrict selecting from a table..
I have problem with one check,
I have select and after this insert based on the select. If it happen
in one time .. I can insert incorrect information. If I do lock table
SOMETABLE read; it still select and return results normaly. I'm open
for suggestions :)
P.S. Excuse my bad english :)
Re: Restrict selecting from a table
Please state the problem.
You mean there's a problem if something changes between the select
and the insert?
If using LOCK TABLE works, why not use it? That's what it's for.
It would appear, though, that you need lock table sometable write,
though, since you're inserting.
Gordon L. Burditt
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum