SQLite3 error when setting Output Format to "table" (.mode table)

Question

I am using SQLite3 on WSL2 (Ubuntu 20.04). When I attempt to set the output format mode to table, I get the following error:

sqlite> .mode table
Error: mode should be one of: ascii column csv html insert line list quote tabs tcl

I've updated SQLite3 to the most current version, and I am still not seeing "Table" as an option.

According to the SQLite3 documentation, I should be seeing 14 different modes to choose from.

Thank you!

3.31.1 - When I update sqlite3 in WSL2 I get "sqlite3 is already the newest version (3.31.1-4ubuntu0.2)" — Dan G, Sep 12 '21 at 22:06
The solution to your (and my) problem should lie [here](https://stackoverflow.com/questions/64861331/how-can-i-install-or-upgrade-to-sqlite-3-33-0-on-ubuntu-18-04). — andylib93, Sep 13 '21 at 15:25

score 0 · Answer 1 · answered Jun 12 '22 at 18:53

0

WSL2 does not have the latest version of sqlite3.

The solution is to upgrade using the instructions here:

How can I install or upgrade to sqlite 3.33.0 on Ubuntu 18.04?

answered Jun 12 '22 at 18:53

Alex R

1 Answers1