fenway

Just add yet another join.

You'd have to run another query on this output as a dervied table to figure it out -- and I'd use column aliases in general.

Well, then EXPLAIN the inner queries.

Just a multi-table update, with the "uid" as the ON clause.

Wait -- you're adding tables dynamically too?

Well, still, DECIMAL is the correct choice -- as for validation, that's not mysql's fault.

Your strings aren't quoted.

See here -- trivial to use date math and generate what you need.

How about a simple encrypt/decrypt of a test string/

Why not a simple UPDATE query?

VARCHAR will accept anything -- I don't believe it.

Sounds like you need an EAV table.

The refman is your friend!

Why would you be adding columns DYNAMICALLY?!?!?

SELECT LOG10(`votes`)+(-1*(TIMESTAMPDIFF(SECOND,'2010-01-19 11:00:00',`published`))/45000) AS ranking FROM post ORDER BY ranking DESC;

Not sure... whatever's throwing that failed dependency error .

Is this a one-time thing? Why are they the same in both tables?

You don't want FLOAT, you want DECIMAL... which version?

Well, my approach involves generating a table, on the fly, of years and months for the range you want -- the rest is easy.

Why not just copy over the log? Or use replication?

Yeah, that's more tricky... you'll have create a derived table contain a row for each month required, and then LEFT JOIN that in. Easy to do if you have an integers table lying around.

No kidding... SELECT * FROM EVENT_TABLE where EVENT_TYPE_ID IN( 1,2,3, 6, 10, 11, 13, 15, 16, 34);

FULLTEXT is funny if you don't have a lot of records -- also, what's your min_word_length?

Sorry, I don't actually see an error here.

You can't do that -- that' a cartesian product. You need to JOIN the two tables, and then, depending on what's in that column, use COALESCE().