From mysql CLI is there a way to get the explain plan for a query sourced from a file?

Question

From MySQL CLI is there a way to get the execution plan of a query sourced from a file?

Assuming the following query in a file some-sql.sql

select *
from table

Called via:

mysql> source some-sql.sql

Is there a way to obtain an execution plan for this query?

score 1 · Accepted Answer · answered Jul 05 '12 at 18:54

1

Add 'explain' clause as first line in .sql file.

answered Jul 05 '12 at 18:54

nsfyn55

1 Answers1