$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 'dt, tm, remoteIP) VALUES (192.168.1.1, 23/Mar/2008,
04:02:02, 77.91.224.1' 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)
)";