Open an existing sqlite database by sqlite3 on linux machine

by Denis   Last Updated July 11, 2018 23:06 PM

I'm very new to databases and SQL, but have to perform select command on already existing sqlite database.

I have:

  1. globally installed SQLite version 3.6.20 on the cluster

  2. file GBSV2.db

I tried the following and got error:

sqlite> ".open /mnt/lustre/Db/GBSV2.db"
   ...> select DISTINCT chromosome from cutPosition
   ...> Error: incomplete SQL: ".open /mnt/lustre/Db/GBSV2.db"
select DISTINCT chromosome from cutPosition

How can i fix it?

Tags : sql sqlite

Related Questions

SQLite copy a sample of the database

Updated August 11, 2015 18:02 PM

select all rows with a minimum value

Updated June 02, 2015 03:02 AM