----- 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 it possible to insert from a select. > > Something like > > insert into table_a from select * from table_b where blah=somevalue > > Thanks, > > David McInnis query like; insert into table_a select * from table_b where blah=somevalue Kittiphum Worachat,MT. www.hatyailab.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php