Re: [sqlite] SELECT INTO ... not supported?

On 8/18/07, John Machin <[EMAIL PROTECTED]> wrote: > Something as simple as > SELECT * INTO tblcopy FROM tbl; > (where tbl is an existing table) gets the following error: > SQL error: near "INTO": syntax error > [version: 3.4.2 on Windows XP] > > I note that this syntax is not mentioned

[sqlite] SELECT INTO ... not supported?

Hi all, Something as simple as SELECT * INTO tblcopy FROM tbl; (where tbl is an existing table) gets the following error: SQL error: near "INTO": syntax error [version: 3.4.2 on Windows XP] I note that this syntax is not mentioned on the supported SQL syntax web page for SELECT, but