in reply to perl and sql
mysql < text_file_containing_sql
I'll leave it up to you to figure out how to put the sql on the command line instead of a file and also how to execute a shell command from perl. My suggestion is to get the command correct from the command line and then move that into your script.
-derby
|
|---|