i see at least 2 issues in your code:
1) you should use an AUTO_INCREMENT column ti store id as stated by others
2) you should use $dbh->quote() instead of $msubject =~ s/\'/\\'/g