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
Post a Comment