Re: explain a prepared statement

[Rick James]

mysql> use database_test;
mysql> SET @test_parameter = "xxx"; 
mysql> SELECT * from table1, table2 where field1= @test_parameter and ....

or

mysql> use database_test;
mysql> SELECT * from table1, table2 where field1= "xxx" and ....

also

mysql> use database_test;
mysql> EXPLAIN SELECT * from table1, table2 where field1= "xxx" and ....

In other words, don't do PREPARE and EXECUTE. Those are reserved for STORED PROCEDUREs, and are used in certain APIs.