You want to use the .import command. See below:
[ramanujan:~]$cat demotab.txt
44 92
35 94
43 94
195 49
66 28
135 93
135 91
67 84
135 94
[ramanujan:~]$echo "create table mytable ( col1 int, col2 int);" | sqlite3 foo.sqlite
[ramanujan:~]$echo ".import demotab.txt mytable" | sqlite3 foo.sqlite
[ramanujan:~]$sqlite3 foo.sqlite
-- Loading resources from /Users/ramanujan/.sqliterc
SQLite version 3.6.6.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from mytable;
col1 col2
44 92
35 94
43 94
195 49
66 28
135 93
135 91
67 84
135 94
Note that this bulk loading command is not SQL but rather a custom feature of sqlite. As such it has a weird syntax because we're passing it via echo to the interactive command line interpreter, sqlite3.
In Postgres the equivalent is COPY FROM:
http://www.postgresql.org/docs/8.1/static/sql-copy.html
In MySQL it is LOAD DATA LOCAL INFILE:
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
One last thing: remember to be careful with the value of .separator. That is a very common gotcha when doing bulk inserts.
sqlite> .show .separator
echo: off
explain: off
headers: on
mode: list
nullvalue: ""
output: stdout
separator: "\t"
width:
You should explicitly set the separator to be a space, tab, or comma before doing .import.