A

Admin • 831.35K Points
Coach

Q. Can stored procedures execute dynamic SQL in MySQL?

  • (A) Yes, using PREPARE and EXECUTE
  • (B) No, only functions can execute dynamic SQL
  • (C) Yes, using CALL statement
  • (D) No, MySQL does not allow dynamic SQL
Explanation by: Admin
Dynamic SQL can be executed with PREPARE, EXECUTE, and DEALLOCATE statements inside procedures.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.