Re^2: how to store text file information into my sql database

To split on \t seems the solution at your problem (already posted above).

my $query = 'INSERT INTO student (StudentId,Name,Dept,address,city) VA
+LUES (?,?,?,?,?)';
[download]

but the quote delimiter in this code is weak and could break easely. "insert..... "; is better.

why don't you replace all ' by \' in the values ?

Peace

Comment on Re^2: how to store text file information into my sql database Download Code

Replies are listed 'Best First'.
Re^3: how to store text file information into my sql database by poj (Abbot) on Jan 03, 2016 at 17:44 UTC
but the quote delimiter in this code is weak and could break easely. "insert..... "; is better. Why are double quotes better when there are no variables to interpolate ? poj	[reply]