MySQL clear query cache
Book page
Instead of being asleep at 23:30 on 11 February 2008, kitt created this:
MySQL clears the query cache after any changes to the tables used in a cache query. Any of INSERT, UPDATE, DELETE, TRUNCATE, ALTER, DROP TABLE or DROP DATABASE potentially remove queries from the cache.
You can manually clear the query cache with RESET QUERY CACHE.