Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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

This comment has been minimized.

Copy link

@alaa-abdelsamie alaa-abdelsamie commented Jan 2, 2018

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