Select Code to Download

              
my $update="UPDATE `ml_message` SET `message_send`='N',`message_has_be
+en_sent`='2010-12-06 10:59:20' WHERE `message_id`=3;";
...
$dbh->do($update)
  or die "problem while updating: $dbh->errstr \n";

--
...
INSERT INTO `test_table` (`test_id`, `test_cl_1`, `test_cl_2`) VALUES
(3, 1, '2010-12-07 14:01:28'),
(4, 0, '2010-12-07 14:04:35');

use strict;
use warnings;
...
                        
$dbh->do($update)
  or die "problem while updating: $dbh->errstr \n";