Posted by David Haynes on 10/19/05 14:50

opt_inf_env@yahoo.com wrote:
> Hello,
>
> On my server users have access to MySQL database (through PHP). What I
> would like to avoid is parallel execution of commands. I mean, if one
> user run some sequence of command the sequence of commands run by
> another user should stay in query till the first sequence is finished.
> Is it possible to reach this only with the usage of "mysql_connect"
> in the beginning of sequence of command and "mysql_close" in the
> end. In another words, is it true that another user cannot make
> connection with DB and execute commands before the first user close
> connection (with "mysql_close")?
>
I don't think so. I think you need to read Section 13.4 of the MySQL
manual (MySQL Transactional and Locking Statements).

-david-

[Back to original message]