Re: explain a prepared statement

[Dorian Kuroki]

Hi,

From the mysql command line.

I need to know what is the way to see the execution plan of a prepared statement:
For example:

mysql> use database_test
mysql> prepare stat_test from " SELECT * from table1, table2 where field1= ? and ....";
mysql> SET @test_parameter = "xxx";
mysql> EXECUTE stat_test USING @test_parameter;
--- RESULT SET IS OK
mysql> explain EXECUTE stat_test USING @test_parameter;

ERROR 1146 (42S02): Table 'database_test.execute' doesn't exist


Many thanks

Dorian