On 18 Apr 2011, at 4:45am, mhnSqlite wrote:

> I am attempting to copy records from one table to another using the syntax :
> Select field1, field2 into {empty table just created} from {existing table
> with a bunch of records}

INSERT INTO newTable SELECT this,that FROM oldTable

<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

Reply via email to