Public feed
#725695
546 my $query = 'load data infile ? into table ? fields terminated by ,';547 warn info_H."Query: ".$query."\n";548 my $dbh = DBI->connect('DBI:mysql:'.$dbDbName.':'.$dbServerIP, $dbUserName, $dbPasswd) or die("Could not connect to DB.");549 my $sth = $dbh->prepare($query);550 warn info_H."Query: ".$query."\n";551 warn info_H."Params: ".$filename.", ".$tablename."\n";552 $sth->execute($filename, $dbDbName.".".$tablename) or die("Could not execute query");553 $sth->finish();554 $dbh->disconnect;ERROR: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 ''test.' fields terminated by ,' at line 1 at ./UVDbuplaod1.pl line 552.Using mysql-4.1Logs:2007/10/04 10:07:04 INFO: UVDbuplaod1.pl::main::main: Query: load data infile ? into table ? fields terminated by ,2007/10/04 10:07:04 INFO: UVDbuplaod1.pl::main::main: Query: load data infile ? into table ? fields terminated by ,2007/10/04 10:07:04 INFO: UVDbuplaod1.pl::main::main: Params: /homes/ddutta/UVTestEnv/cfg_root/200706/data/uv_dbuplaod/broadband_high_low_products_dbformat.txt,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 ''test.' fields terminated by ,' at line 1 at ./UVDbuplaod1.pl line 552.