Amer Neely wrote:
<snip>
I'm pretty sure it's not. With a properly functioning mysql server, you need neither FLUSH TABLES nor the RELOAD privilege to delete a row from a table. See the manual for a description of FLUSH TABLES <http://dev.mysql.com/doc/mysql/en/FLUSH.html>.
I did and imagine my surprise when I read this:
"You should use the FLUSH statement if you want to clear some of the internal caches MySQL uses. To execute FLUSH, you must have the RELOAD privilege."
There is a subtle difference between actually deleting a row and whether MySQL shows it to you or not. Even though the row is still in the table, a query from the perl script that I used to 'delete' it didn't return it. It had been flagged as deleted for that session, but that is not the same as being deleted. Which is why it was visible from another script.
That's not what that means. If a table has been changed (row deleted), the cache is no longer valid and must be updated. Running FLUSH TABLES is *NOT* part of deleting rows.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
