$insertData = "INSERT INTO url_Connect (sourceIP, dt, tm, remoteIP) VALUES ( $sourceIP, $date, $time, $targetIP )"; $dbMake = $dbi->prepare($insertData); $dbMake->execute(); #<-----line 86 #### DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '192.168.1.1, 23/Mar/2008, 04:02:02, 77.91.224.11)' at line 2 at createDB.pl line 86 #### my $createTable = "CREATE TABLE IF NOT EXISTS url_Connect( sourceIP varchar(16) primary key, dt date, tm time, remoteIP varchar(16) )";