Error when using changing mode to csv

Question

I am trying to import data from a csv file. According to this , I should use .mode csv first. But when I enter that command, I get this error:

mode should be on of: column html insert line list

Why is this so ? Google didn't help me much and I'm new to this.

Answer 1

You had probably entered on the SQLite shell using sqlite. Try to use sqlite3 to enter on the shell. There you will have the .mode csv.