Re: Insert from select

2002-03-16 Thread Georg Richter
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 --

Re: Insert from select

2002-03-16 Thread Kittiphum Worachat
- 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

Insert from select

2002-03-16 Thread David McInnis
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 ---