fenway

Looks like TIME to me.

Can't possibly debug that until I see actual mysql queries. And why aren't the PKs auto-increment?

Seriously, stop -- you're new at this -- don't even start to playing with NoSQL at this stage.

I wasn't kidding -- don't even start to try. Non-relational databases are quite a different beast.

My guess is that you didn't alias your expression, and you're asking for the value back from a hash.

Since you don't know the answer, you can't determine which pieces of information are relevant or not. What makes you think you can even make a hash index? Why do you think you need to care about block size? You haven't even explained what this table is for.

Don't even bother trying to emulate anything of that scale.

That's not helpful -- what column, and what value?

That's not a problem per se. Add a column labeled "type" to your output, and then in php you can format it however you desire. Alternatively, I suppose you can use each one a scalar subquery, too.

You can use ORDER BY FIELD() if you know the order your want.

You will have, or you do have? How are you querying this table?

Oh, I see know -- that's a strange query. Easiest way is to switch your WHERE to an OR, and then use IFs to check the boolean condition. SELECT SUM( IF( em.email = '123.hotmail.com', 1, 0 ) ) AS email, SUM( IF( us.user = 'jay', 1, 0 ) ) AS users FROM members em LEFT JOIN members us ON em.email = '[email protected]' OR us.user = 'jay1' But that's not ideal for index usage -- why not just UNION the results?

Well, that depends what data you'd like to delete.

That's a ridiculously large topic -- and there is no right answer. What are you planning on searching?

That's all well and good -- but until you post the equivalent select statements, and their EXPLAIN output, I can't help you.

How much of it don't you understand?

If you're asking how to write php script to do this, you're in the wrong forum.

FULLTEXT is the best internal way to go...

You need to use last_insert_id() to get the newly created member's uid, then simply pass it through.

That's not the correct syntax -- check the refman. No -- why separate two intricately related pieces of information?

You can, with magical TIMESTAMPs.

3 tables, then?

Are you certain? Post explain output for the equivalent selects.

And you can't just join in those tables?

Why e-mail = 2? They are different users.