A

Admin • 831.35K Points
Coach

Q. Can you use dynamic SQL inside stored procedures?

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

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.