fenway

You can't do "second to last" -- but you can do second -- so just flip the order clause around.

Well, from the CLI, you can specify how you want your output to be show -- either with \G or with pager.

You may be getting inconsistent data across tables.

What makes you think this is possible?

That's basically it... did you try it?

Or, run a sanitize script that converts these magic characters -- which often crop up when people C&P from Word -- into regular, ASCII characters.

Move the check for TTL > 3 to a HAVING clause -- the result isn't available until "after" the query runs.

Well, a table structure would help.

Depends if you're using strict mode or not.

Well, mysql goes from left-to-right, so you should be ok.

MySQL doesn't "display" anything related to cells... what do you mean?

No, you shouldn't use HAVING... and the difference between COUNT(*) and COUNT(col) only has to do with NULL values.

You need group_concat().

Sounds like you just need a COUNT and a GROUP BY.

FYI, MySQL has no problem storing partial dates.

I'm not sure I follow... did you try adding the where clause directly?

Well, it's still limited to 65k.

Or use SHOW CREATE TABLE.

Echo the actual queries, not your code.

The query determine what "matches" -- with your LEFT JOINs and such -- and you choose with matching table rows get deleted.

The refman is your friend.

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).