in reply to Updating fields in a mysql database

Another option, using the DBI module (check the perldoc DBI for syntax), is read the information in your table, and as long as you read every entry, if the email doesn't exist, do an INSERT statetement, and if it exists and what you want is to update the information, execute an UPDATE statement using the email in the WHERE clause. (check any tutorial on SQL to check the syntax).
  • Comment on Re: Updating fields in a mysql database