fenway

That still means you want a query to run periodically -- 5.1 has an event scheduler built-in.

I've no idea what you thought this had to do with MySQL. This topic has been moved to HTML Help. http://www.phpfreaks.com/forums/index.php?topic=311085.0

I don't understand -- you want to run the query every X, or the result to be based upon X?

Well, maybe I don't understand what you're trying to achieve.

I still don't see why you just can't join it directly and combine the ON conditions.

Why do you have a subquery in the right join?

Yeah, don't.

There are no materialized views in mysql, so it's basically the same.

Only on the "right" table of any join.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=310669.0

There's no "locking read" -- that's pessimistic locking that you'll have to build into your application.

What language are you storing?

Then you've got a php problem.

Now I'm really confused -- what are you trying to achieve here?

Drop the GROUP BY / aggregate part, make sure it's reasonable output

Of course... I simply assumed that's why distinct was there to begin with. That's what I get for not reading.

I don't understand what you mean...

Sorry, I'm very confused -- how does DISTINCT return more than one row here?

Use IN, not =.

Covers: Part 1: Using the MySQL Improved Extension, mysqli Part 2: Using the MySQL Extension, mysql Part 3: Using the PDO Extension With MySQL Driver, pdo_mysql Part 4: Using the MySQL Native Driver for PHP, mysqlnd Tutorial is here.

Well, a scalar subquery, that is.

Hopefully this presentation will stay online at scribd... it's simply fantastic, probably the best I've come across in recent memory. At 220 slides, it's quite lengthy -- but the lessons learned are invaluable, so be sure to read all the way to the end. A MUST READ!!!! EDIT: This year's version of the presentation -- some really great stuff in here, particuarly about hierarchies.

At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets (PDF).

This resource covers a very broad range of topics... it's worth a look, though, especially if you're stumbling in the early stages of configuration.

Basically, this blog contains a regularly-updated run-down of MySQL functions, with a short description and a few hints on how to use them; RSS feed here.