Dynamic SQL
“Dynamic” means that the SQL statement that you execute is constructed, parsed, and compiled at runtime, not at the time the code is compiled. Dynamic SQL offers a tremendous amount of flexibility—but also complexity and more than a little risk.
In the MySQL stored program language, you can process dynamic
SQL by using the MySQL prepared statement feature. You can
create a prepared statement with the PREPARE
statement, supplying the SQL text in
a session variable. The SQL can then be executed with the EXECUTE
statement.
Get MySQL Stored Procedure Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.