On Sep 16, 2011, at 9:27 PM, Jim Michaels wrote: > currently, sqlite only handles 1 row. > INSERT INTO table(digit,dialpadstr) VALUES > (2,'abc');
try: insert into foo ( bar ) select 1 as bar union all select 2 as bar etc... Please refer back to the fine manual: http://www.sqlite.org/lang_insert.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
