You are connected to a MySQL server and using a prepared statement. You accidentally
exit your session.
What will happen if you log back in to use your prepared statement?
A.
The statement exists, but will need to be deallocated and re-created.
B.
The statement exists, but the user variables need to be redefined.
C.
The statement can be used, if the MySQL server hasn’t been restarted.
D.
The statement no longer exists.
Explanation:
Reference:
http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html
D:
http://dev.mysql.com/doc/refman/5.6/en/sql-syntax-prepared-statements.html
“A prepared statement is specific to the session in which it was created. If you terminate a session without deallocating a previously prepared statement, the server deallocates it automatically.”
agree with D.
I test it.
D