MySQL Forums
Forum List  »  Optimizer & Parser

prepare don't work for optimize statement
Posted by: Long WU
Date: March 22, 2017 12:30AM

why I have below error?

mysql> prepare stmt from "optimize table ? ";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1

it's the same error message I got when I use optimize in my procedure. SO it's the same error, but I don't understand why I got this.

could you please hepp expert??

Options: ReplyQuote

Written By
prepare don't work for optimize statement
March 22, 2017 12:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.