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!

It would be nice if you added your trick to "Hidden Features of" question. It is seen much often and "ORDER BY FIELD" is nice feature. — LukLed, Jun 15 '10 at 18:55
+1: Not for question but for this `ORDER BY FIELD` answer. I came to this questions searching for custom ordering :) — shamittomar, Sep 02 '10 at 06:53

score 2 · Answer 1 · answered Jun 15 '10 at 18:14

2

Use EXPLAIN to profile the query execution plan

answered Jun 15 '10 at 18:14

Srikar Doddi

Just to add to it -- this is an incredible tool to optimize a query – Kerry Jones Jun 15 '10 at 18:19
1

How is `EXPLAIN` unique to MySQL? – Dolph Jun 15 '10 at 18:23

score 1 · Accepted Answer · answered Jun 15 '10 at 18:23

1

Want to export a table?

Use SHOW CREATE TABLE customer to generate a create query.

answered Jun 15 '10 at 18:23

alexn

2 Answers2