Ivan D wrote:
> and the bonus of being able to do 2 or more queries at once can be pricelessly helpfull.
Would you care to give an example of this?
> If i'm absolutely sure the parses won't be of malicious nature, can i turn on multi queries
> somehow?
Not unless you change the source code of the library that implements the PHP-MySQL interface.
But there really is no point (as explained in my previous post).
> Howcome phpadmin doesnt care about multi queries?
Don't know. Look at the source code. Maybe phpadmin parses the statements and feeds them one by one to MySQL.
> When you lock a table, does the script that locked it only have access?
> What if they terminate before unlocking?
> What kind of access do other scripts have, just read?
> Are there different kinds of locks?
> Is there anyway to do a select and some other query (like UPDATE) and still get the results from
> the select?
All these questions are answered at great length in the MySQL reference manual. If you want to bring your MySQL expertise to a higher level, you will have to study the relevant sections in detail.
--
felix
Please use
BBCode to format your messages in this forum.