Re: Syntax Error on Sproc

[Peter Brawley]

Time stub:

...
SET @query3=...
SELECT "Before query3", Now();
EXECUTE @query3;
SELECT "After query3", Now();
...

Display query:

...
SET @query3=...
SELECT @query3;
...

Copy and paste that query into a text editor, add EXPLAIN EXTENDED to the front of it, and run that command in the mysql client.