On 18/08/2007 12:17 PM, Igor Tandetnik wrote:
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
This should have given you a hint. A web page for CREATE TABLE however
documents this:
create table tblcopy
as select * from tbl;
Thanks, Igor, that does the trick.
Cheers,
John
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
