Generating on-the-fly SQL scripts for batch mode
When writing scripts for running MySQL in batch mode, it is often desired to be able to change the SQL queries on-the-fly so that we can use the script to solve more generic problems.
For example, I need to use my script for different storage engines and table names and I want to be able to do it at runtime instead of manually changing my script every time.
This blog post shows you how.