On Saturday, 16. March 2002 09:26, David McInnis wrote:
> I think that I saw a similar query last week some time but I cannot
> remember the sql syntax. Is it possible to insert from a select.
See http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Regards Georg
--
- Original Message -
From: "David McInnis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 16, 2002 3:26 PM
Subject: Insert from select
> I think that I saw a similar query last week some time but I cannot
> remember the sql syntax. Is
I think that I saw a similar query last week some time but I cannot
remember the sql syntax. Is it possible to insert from a select.
Something like
insert into table_a from select * from table_b where blah=somevalue
Thanks,
David McInnis
---