fenway

I would allow for storage for most of the fields, no need to cut it close for a few bytes -- otherwise you'll have to deal with truncation issues/warnings. As for the images, you should store in on the file system, and record a relative path in the db.

Overhead in the result of "holes" from deleting records. As for your inserts, they can't just fail and not report and error... unless you're not checking.

That error message doesn't help... is this your server, or on a host?

80 fields of customer information?

And you can drop that index of "x".

The first code that I gave you works when I tested it... what version are you using?

DUMPFILE? shouldn't it be OUTFILE?

Only for US users? What's imagefile?

It's still a poor choice.

Just get another bunch of programmers / developers to try and break it... as for the small stuff, that will come up no matter how many times you test it.

You can't -- that is, you shouldn't.

Filesort?

Yes, but it's a parallel and stateless version. I think you should investigate the source of the crashes... maybe a particular table, etc.?

I'd lke to see an EXPLAIN, too.

Apparently, I've never used this function for this purpose in this language... it always takes a length, so SUBSTRING( post FROM LOCATE('http://',post) FOR ( LOCATE(' ',post, LOCATE('http://',post)- LOCATE('http://',post) ) ) -1) AS url Should work.

It's just like any other select, example you store the result set in a file.

Well, you'll have to store it somewhere...

And what would your fields represent/

Perhaps you're using the wrong syntax -- you might be using the second value as the length of the string to return, not the index.

You need to start the server without grants.

Have you check out maatkit? They have some live backup tools...

I guess you could run an SP that populates a summary table... this is similar to what you have done with serializing magic.

You don't need HAVING ... you need WHERE t.staffID IS NULL.

That's no really possible... post the value of "post" in your example.

But if you limit by MONTH(), you won't get the other months automatically!