fenway

Still, which table type?

Don't think this is a mysql-related issue....

Is there replication involved? Are you the only one with access to this DB?

There's a sticky with some resources like the ones you need.

Good luck telling that to the client.

Your syntax is a bit off... USING is wrong here (the column names aren't the same in both tables), and you need an ON clause. Try this: DELETE FROM pages,children LEFT JOIN children ON ( pages.id = children.childid )WHERE pages.id='$pageid'

By "skip", you mean there were no entries for them in your DB?

Such a complicated question... really depends on how the buffer pools, etc. have all been set up.

localhost and 127.0.0.1 are not necessarily equivalent, especially on linux, unless they have been defined as such.

How? Enlighten us.

Please post your solution.

Really? Using an experimental release for critical data? Oh well.... Are we talking about MyISAM tables here? What makes you think phpmyadmin is telling the truth?

Seriously? That's pretty much impossible to start with.

First, you probably don't need to case all of those -- mysql deals with datetime<=>date conversions quite well. Second, what are you trying to achieve?

Why? Just run a single function for each perison.

Why not make your own list? I'm confused.

There is a FLUSH TABLES command, but I doubt that's the issue.

Tuples in the DB?

You sure mysql is correctly configured?

Please don't use TEXT.... it's horrible... if you're using mysql5, varchar goes up to 65k.

An example of the insert statement and the table definition would help, too.

Yes, that is the hard way... usually, you get the most recent for each one, then join that table back.

Yes, be very careful about this!

Why not use SUM( IF( yourfield between x and y), 1, 0) multiple times?

That's wrong... you want CURDATE() - INTERVAL 7 DAY