fenway

What do you have so far?

PHPMyAdmin can help you make tables quite easily.

Perhaps posting the query would help.

You're talking about storing hierarchical data... there many resources available, including some in the stickies.

Yes, you'll have to store the time of the last download.

Just remember mysql will use the full 255 for any group by or sorting/ordering operations performed on the column, so performance suffers if the value is set too high.

Optimization without specific queries is impossible.

Assuming proper index usage.

MD5 is not encryption -- it's a one-way hash function. And if you're asking how to use mysql from flash, this isn't the right place.

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?