Perl: the Markov chain saw | |
PerlMonks |
Re: dynamic bulk insert in sqliteby erix (Prior) |
on Sep 22, 2012 at 08:29 UTC ( [id://995080]=note: print w/replies, xml ) | Need Help?? |
Assuming there is a header line: just chop off the first line (the header line) and split that into an array. With that array, build a create table statement (it's often necessary to sanitize the column names), and send it to SQLite. After that, just send the whole file *except* the first line. If there is no headerline, generating the column-names + create table statement is obviously even easier. (The whole procedure is not SQLite specific either, the bulk loader used will differ per DBMS)
In Section
Seekers of Perl Wisdom
|
|