sqlite - Importing Files

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• Text

In the following example you will import a comma-delimited csv file into your sqlite database. We create the table, designate the separator, and import the file.

sqlite> create table test (id integer, datatype_id integer, level integer, meaning text);
sqlite> .separator ","
sqlite> .import no_yes.csv test