Skip to content

Instantly share code, notes, and snippets.

@AmyStephen
Created July 20, 2013 14:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AmyStephen/6045344 to your computer and use it in GitHub Desktop.
Save AmyStephen/6045344 to your computer and use it in GitHub Desktop.
To use EXPLAIN or PROCEDURE ANALYSE in phpMyAdmin
// 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 ()
@alaa-abdelsamie
Copy link

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 .

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment