On 25 Mar 2016, at 11:33am, Richard Hipp <drh at sqlite.org> wrote: > On 3/25/16, Simon Slavin <slavins at bigfraud.org> wrote: > >> There is no COPY command in SQLite. > > There *was* a COPY command, way back in SQLite 2.x. It was omitted > from SQLite3, circa 2004.
Wow. On 25 Mar 2016, at 12:22pm, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote: > But discovered that it can be somehow emulated by "import tablename" using > csv. > > Would be a good idea to have the complementary of ".import" -> ".export". You can get export to .csv files using .mode csv .once filename.txt .SELECT * FROM tablename If you want tabs instead of commas, use ".mode tabs" instead. Simon.
