mhnSqlite <[email protected]> wrote:
> I am attempting to copy records from one table to another. The following
> statement is what i see everywhere when I google how to do this, yet it does
> not work.
> I am using the following:
> Select field1, field2 into {newly created table} from {existing table with
> lotsa records}
> I get an error Error near "Into"
SQLite doesn't support this syntax. I don't believe it's standard - likely a
non-standard extension of some particular DBMS.
In any case, you have been given the answer already, at least twice. Here it is
again:
insert into {newly created table} (field1, field2)
select field1, field2 from {existing table with lotsa records};
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
