Yes, a few ideas:

• use DBI;
• and MySQL
• do some reading

and come back with real questions... So far it seems you have the right idea, but no code will get you nowhere around here. You need to show some effort as well.

#!/home/bbq/bin/perl
# Trust no1!