Re: "This command is not supported in the prepared statement protocol yet"

[Harrison Fisk]

Hi,

A few notes:

1. Generally you shouldn't use prepared statements for every single query, as prepared statements can be slower if you are just executing a query once.

2. The queries that are commonly used with placeholders were the first ones that were done. CREATE TABLE was done because it is commonly used with SELECT, as in CREATE TABLE....SELECT... (for temporary tables very commonly). I can't be more precise when others will be added unfortunately, as it isn't a very high demand item.

3. I agree the limitation should be documented better and I have filed a bug at http://bugs.mysql.com/bug.php?id=6415 Feel free to track it to see when the docs are changed.

Thanks for the feedback.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com