fenway

Then you have a php problem.

Yeah, don't.

Don't double-post.

No delimiter.

That's not possible... show the explain output again.

Yup... FROM_UNIXTIME().

Missing semi-colon.

You can't use WHERE with INSERT... doesn't make any sense... do you mean UPDATE?

Sure there is... so how did you solve it?

That's odd.

The issue is that GROUP BY returns almost always absolute nonesense for any columns other than the ones you specify in the group by clause.

Either way, I don't understand why the query wouldn't work.

Well, you can use a covering index on both columns, but that's only going to get you so far.

Hmm.. I've only ever encountered this when there's a whitespace character hiding somewhere... can you try settting sql_mode = IGNORE_SPACE just to prove me wrong?

First you need to write the query to produce the desired logic... then wrap it in a trigger.

There are some other issues first, like mixing * and GROUP BY

You'll have to strip out the first character, cast it to a number, and hope that mysql will do the rest.

No, it's in the my.cnf / my.ini file, if it's set. Altenatively, you can simply SELECT @@GLOBAL.sql_mode;

Just create a single folder per "filetype", then santize the file and include the UID in the filename.

Wait, why?

You're ordering by an expression.

Yikes... dependent subquery & no index usage?

Just remeber that timezone "magic" only works on timestamp fields.

I don't really understand.

We have some pretty good tutorials around here, and in the stikcikes.