Created
July 20, 2013 14:54
-
-
Save AmyStephen/6045344 to your computer and use it in GitHub Desktop.
To use EXPLAIN or PROCEDURE ANALYSE in phpMyAdmin
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Normal query | |
SELECT a.id, a.title, b.category | |
FROM table a, | |
table b | |
WHERE a.category_id = b.category_id | |
// EXPLAIN http://dev.mysql.com/doc/refman/5.0/en/using-explain.html | |
EXPLAIN SELECT a.id, a.title, b.category | |
FROM table a, | |
table b | |
WHERE a.category_id = b.category_id | |
// PROCEDURE ANALYSE http://dev.mysql.com/doc/refman/5.0/en/procedure-analyse.html | |
SELECT a.id, a.title, b.category | |
FROM table a, | |
table b | |
WHERE a.category_id = b.category_id | |
PROCEDURE ANALYSE () |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
ooh , i need EXPLAIN
SELECT a.id, a.title, b.category FROM table a, table b WHERE a.category_id = b.category_id PROCEDURE ANALYSE ()
please .