Dear monks, this is a question about sqlite and/or perl.
Indeed I'd like to bulk insert a delimited text into a table, but I'd like doing it dynamically just specifying a table name. I want the fields to be created dynamically according to the number of fields in the text file.
I checked the sqlite import command but it requires a table with the right amount of fields. Also check the DBD and DBI module but could not find anything related.
Now is my question related to what we call virtual tables?
Many thanks for your guidance.