[ILUG-BOM] Some help needed in perl / shell scripting

Hi All, Can someone help this novice with a shamm Shell / Perl script to be executed at the prompt. I have a MySql db with TABLE=TEST FIELD=LIST RECORDs= 1pc49 6qh79 sbe59 etc.

I need a script that will connect to the db and append each record to a text file till end of database. there may be simpler ways to do this, but i need a script to do this as I have further processing to do. the script can be directly executed from promtp as ./script_name

Any pointers will also help.

Thx in advance. Poonam

________________________________________________________________________ Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html