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 on the supported SQL syntax web > page for SELECT, but it's also not mentioned AFAICT in the unsupported > features list on the wiki. > > Am I missing something simple, or is "SELECT INTO" definitely not supported? > > Can anybody help with a workaround that doesn't need an explict (and > rather long) list of fields in the 3-table join that is my real > non-simple requirement?
http://www.sqlite.org/lang_insert.html Regards, ~Nuno Lucas > Thanks in advance, > > John ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------