fenway

Well, the namespace has to be loaded somewhere to deal with ACID transactions.....

Use YEAR()... or EXTRACT() or DATE_FORMAT().

So, solved?

I've never heard of that. If you're starting again fresh, you can use TRUNCATE to empty the table properly, instead of DELETE.

You can use mysql_result( $result, 0, 0 ) and then you don't need an alias, either.

You have to decide how to build your where clause using php logic.

Yes, just modify the MERGE definition whenever you'd like.

No one knows what that means.

There's a variable called max_allowed_packet... but php also have a max size.

Yeah, that.

Not without a HAVING clause.

Could you post the table structures?

Have you been run FLUSH PRIVILEGES?

I assume your text file is UTF08?

Please echo the sql query.

If you GROUP BY, and you want non-aggregate columns, then you'll need to join that table back to itself.

And you don't need DISTINCT, either.

WHY?

What was wrong with: WHERE yourColumn REGEXP '[0-9]%'

I'm saying that it sounds like it would be easier to tweak your existing "script" to handle the new database table.

I agree... TIMESTAMP is evil... who would want to use a field that won't work after 2039?

TIMESTAMP have funny time zone issues.

Stop using DISTINCT and GROUP BY...

If you can dump into CSV, then you can use that file as a DB engine directly in mysql.

I still don't see what that has to do with IPs... by definition, you'll need to connect to the DB with a "common" user, since you can't possibly know the IP in advance.