sqlite - Is it possible to import more than one sqlite3 files from terminal? -


i have 2 databases use in sqlite. both in same folder in terminal. can import 1 command below.

$sqlite3 first.sqlite3 

and jumps sqlite> can see table 'first' , content.

however, import second database sqlite. try

sqlite> .import second.sqlite3 second sqlite> pragma table_info(second); 

it shows

0|sqlite format 3|text|0||0 

, not give me table.

when use

sqlite> select * second; 

, shows

  col1 text,         col2 text,   col3 text,   col4 text ) 

does know how solve this? appreciate help. thank much!

i think need attach database:

sqlite3 first.sqlite3 attach 'second.sqlite3' second; 

Comments

Popular posts from this blog

sql - invalid in the select list because it is not contained in either an aggregate function -

Angularjs unit testing - ng-disabled not working when adding text to textarea -

How to start daemon on android by adb -