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