Mysql ninja tricks

Question

Possible Duplicate:
Hidden Features of MySQL

Hi,

what are your mysql ninja tricks? What features are extra special?

I'm starting with ORDER BY FIELD which enables you to sort in a particular order, like this:

SELECT url FROM customer ORDER BY FIELD(customer.priority, 1, 2, 3, 0)

Features like this is hard to find in the mysql documentation.

Bring it!

Answer 1

Use EXPLAIN to profile the query execution plan

Answer 2

Want to export a table?

Use SHOW CREATE TABLE customer to generate a create query.