10 messages in com.mysql.lists.win32HELP with "INSERT SELECT"
FromSent OnAttachments
Daniel Bronzeri Barbosa22 Sep 2004 04:01 
Patino, Hernando22 Sep 2004 05:42 
SGr...@unimin.com22 Sep 2004 06:18 
Daniel Bronzeri Barbosa22 Sep 2004 06:28 
Jordan Sparks22 Sep 2004 07:21 
Catapult Webmaster22 Sep 2004 07:38 
Randy Clamons22 Sep 2004 13:37 
Michael Crowl22 Sep 2004 14:07 
Randy Clamons22 Sep 2004 14:41 
Michael Crowl22 Sep 2004 14:49 
Subject:HELP with "INSERT SELECT"
From:Daniel Bronzeri Barbosa (dan@arccorp.com.br)
Date:09/22/2004 04:01:37 AM
List:com.mysql.lists.win32

How I can Insert 2 records with a Insert Select?

The SQl Clause that I am using is this:

Insert into fun_informations (Select conn.INT_InternalCallId as INT_InternalCallId, 'CID' as CHR_PropName, 'AAAAAA' as CHR_PropValue, 1 as INT_Updated, null as INT_Key from cti_connections conn left join app_ivrtable ivr on conn.chr_device=ivr.chr_device where conn.int_state = 7 and ivr.CHR_Machine = 'm1' and ivr.INT_IVRLine = '1')

but I wanted to insert given of this clause

Insert into fun_informations (Select conn.INT_InternalCallId as INT_InternalCallId, 'CID' as CHR_PropName, 'AAAAAA' as CHR_PropValue, 1 as INT_Updated, null as INT_Key from cti_connections conn left join app_ivrtable ivr on conn.chr_device=ivr.chr_device where conn.int_state = 7 and ivr.CHR_Machine = 'm1' and ivr.INT_IVRLine = '1'), (Select conn.INT_InternalCallId as INT_InternalCallId, 'CPN' as CHR_PropName, 'BBBBB' as CHR_PropValue, 1 as INT_Updated, null as INT_Key from cti_connections conn left join app_ivrtable ivr on conn.chr_device=ivr.chr_device where conn.int_state = 7 and ivr.CHR_Machine = 'm1' and ivr.INT_IVRLine = '1')

It is possible? If not how i can do this?

Tks,

Daniel