Nested inserts possible?

I have two tables and I have data to insert into both at the same time,
but the second table depends on an ID that is auto created in the first
table. I'm not sure exactly how to accomplish this.

Table_One

Table_One_Index_ID
Data_One
Date_Two

Table_Two

Table_Two_Index_ID
Table_One_Index_ID
Data_Three
Data_Four




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Nested inserts possible?

Keith,
You will need to reference the mysql_insert_id() function after
adding the row to Table_One. Then use the value returned for the rest of
the tables.

http://dev.mysql.com/doc/refman/5.1/en/getting-unique-id.htm l

Mike

At 08:48 AM 3/12/2010, you wrote:
>I have two tables and I have data to insert into both at the same time,
>but the second table depends on an ID that is auto created in the first
>table. I'm not sure exactly how to accomplish this.
>
>Table_One
>
>Table_One_Index_ID
>Data_One
>Date_Two
>
>Table_Two
>
>Table_Two_Index_ID
>Table_One_Index_ID
>Data_Three
>Data_Four
>
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=mos99@fastmail.fm


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Nested inserts possible?

--0050450160727da2eb04819c8ab5
Content-Type: text/plain; charset=ISO-8859-1

Have a look at last_insert_id()
..

On Fri, Mar 12, 2010 at 3:48 PM, Keith Clark wrote:

> I have two tables and I have data to insert into both at the same time,
> but the second table depends on an ID that is auto created in the first
> table. I'm not sure exactly how to accomplish this.
>
> Table_One
>
> Table_One_Index_ID
> Data_One
> Date_Two
>
> Table_Two
>
> Table_Two_Index_ID
> Table_One_Index_ID
> Data_Three
> Data_Four
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamp@tuxera.be
>
>


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--0050450160727da2eb04819c8ab5--

Re: Nested inserts possible?

Johan,

That seems to be the ticket. Thanks!

Keith

On Fri, 2010-03-12 at 16:54 +0100, Johan De Meersman wrote:
> Have a look at last_insert_id().
>
> On Fri, Mar 12, 2010 at 3:48 PM, Keith Clark
> wrote:
> I have two tables and I have data to insert into both at the
> same time,
> but the second table depends on an ID that is auto created in
> the first
> table. I'm not sure exactly how to accomplish this.
>
> Table_One
>
> Table_One_Index_ID
> Data_One
> Date_Two
>
> Table_Two
>
> Table_Two_Index_ID
> Table_One_Index_ID
> Data_Three
> Data_Four
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=vegivamp@tuxera.be
>
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Nested inserts possible?

SWYgeW91J3JlIGluc2VydGluZyBtdWx0aXBsZSByb3dzIGluIHRoZSBkZXBl bmRlbnQgdGFibGUg
Zm9yIHRoZSBzYW1lIGlkIGluIHRoZSBwYXJlbnQgdGFibGUsIHlvdSdsbCBu ZWVkIHRvIHNhdmUg
dGhlIHZhbHVlIG9mIExBU1RfSU5TRVJUX0lEKCksIG90aGVyd2lzZSBzdWJz ZXF1ZW50IGluc2Vy
dHMgd2lsbCBjaGFuZ2UgaXQhDQoNCklOU0VSVCBJTlRPIHBhcmVudCBWQUxV RVMgKC4uLik7DQpT
RVQgQGlkOj1MQVNUX0lOU0VSVF9JRCgpOw0KSU5TRVJUIElOVE8gY2hpbGQx IFZBTFVFUyAoQGlk
LCAuLi4gKTsNCklOU0VSVCBJTlRPIGNoaWxkMiBWQUxVRVMgKEBpZCwgLi4u ICk7DQoNCi0tLS0t
T3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBLZWl0aCBDbGFyayBbbWFp bHRvOmtlaXRoY2xh
cmtAay13Ym9va3dvcm0uY29tXQ0KU2VudDogRnJpZGF5LCBNYXJjaCAxMiwg MjAxMCA3OjU3IEFN
DQpUbzogbXlzcWxAbGlzdHMubXlzcWwuY29tDQpTdWJqZWN0OiBSZTogTmVz dGVkIGluc2VydHMg
cG9zc2libGU/DQoNCkpvaGFuLA0KDQpUaGF0IHNlZW1zIHRvIGJlIHRoZSB0 aWNrZXQuICBUaGFu
a3MhDQoNCktlaXRoDQoNCk9uIEZyaSwgMjAxMC0wMy0xMiBhdCAxNjo1NCAr MDEwMCwgSm9oYW4g
RGUgTWVlcnNtYW4gd3JvdGU6DQo+IEhhdmUgYSBsb29rIGF0IGxhc3RfaW5z ZXJ0X2lkKCkuDQo+
DQo+IE9uIEZyaSwgTWFyIDEyLCAyMDEwIGF0IDM6NDggUE0sIEtlaXRoIENs YXJrDQo+IDxrZWl0
aGNsYXJrQGstd2Jvb2t3b3JtLmNvbT4gd3JvdGU6DQo+ICAgICAgICAgSSBo YXZlIHR3byB0YWJs
ZXMgYW5kIEkgaGF2ZSBkYXRhIHRvIGluc2VydCBpbnRvIGJvdGggYXQgdGhl DQo+ICAgICAgICAg
c2FtZSB0aW1lLA0KPiAgICAgICAgIGJ1dCB0aGUgc2Vjb25kIHRhYmxlIGRl cGVuZHMgb24gYW4g
SUQgdGhhdCBpcyBhdXRvIGNyZWF0ZWQgaW4NCj4gICAgICAgICB0aGUgZmly c3QNCj4gICAgICAg
ICB0YWJsZS4gIEknbSBub3Qgc3VyZSBleGFjdGx5IGhvdyB0byBhY2NvbXBs aXNoIHRoaXMuDQo+
DQo+ICAgICAgICAgVGFibGVfT25lDQo+DQo+ICAgICAgICAgVGFibGVfT25l X0luZGV4X0lEDQo+
ICAgICAgICAgRGF0YV9PbmUNCj4gICAgICAgICBEYXRlX1R3bw0KPg0KPiAg ICAgICAgIFRhYmxl
X1R3bw0KPg0KPiAgICAgICAgIFRhYmxlX1R3b19JbmRleF9JRA0KPiAgICAg ICAgIFRhYmxlX09u
ZV9JbmRleF9JRA0KPiAgICAgICAgIERhdGFfVGhyZWUNCj4gICAgICAgICBE YXRhX0ZvdXINCj4N
Cj4NCj4NCj4NCj4gICAgICAgICAtLQ0KPiAgICAgICAgIE15U1FMIEdlbmVy YWwgTWFpbGluZyBM
aXN0DQo+ICAgICAgICAgRm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0 cy5teXNxbC5jb20v
bXlzcWwNCj4gICAgICAgICBUbyB1bnN1YnNjcmliZToNCj4gICAgICAgICAg aHR0cDovL2xpc3Rz
Lm15c3FsLmNvbS9teXNxbD91bnN1Yj12ZWdpdmFtcEB0dXhlcmEuYmUNCj4N Cj4NCj4NCj4NCj4g
LS0NCj4gQmllciBtZXQgZ3JlbmFkeW4NCj4gSXMgYWxzIG1vc3RlcmQgYnkg ZGVuIHd5bg0KPiBT
eSBkaWUndCBkcmlua3QsIGlzIGVlbmUga3dlemVsDQo+IEh5IGRpZSd0IGRy aW5rdCwgaXMgcmFz
IGVlbiBlemVsDQoNCg0KDQotLQ0KTXlTUUwgR2VuZXJhbCBNYWlsaW5nIExp c3QNCkZvciBsaXN0
IGFyY2hpdmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQpUbyB1 bnN1YnNjcmliZTog
ICAgaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1ndG93ZXlA ZmZuLmNvbQ0KDQoN
ClRoaXMgbWVzc2FnZSBjb250YWlucyBjb25maWRlbnRpYWwgaW5mb3JtYXRp b24gYW5kIGlzIGlu
dGVuZGVkIG9ubHkgZm9yIHRoZSBpbmRpdmlkdWFsIG5hbWVkLiAgSWYgeW91 IGFyZSBub3QgdGhl
IG5hbWVkIGFkZHJlc3NlZSwgeW91IGFyZSBub3RpZmllZCB0aGF0IHJldmll d2luZywgZGlzc2Vt
aW5hdGluZywgZGlzY2xvc2luZywgY29weWluZyBvciBkaXN0cmlidXRpbmcg dGhpcyBlLW1haWwg
aXMgc3RyaWN0bHkgcHJvaGliaXRlZC4gIFBsZWFzZSBub3RpZnkgdGhlIHNl bmRlciBpbW1lZGlh
dGVseSBieSBlLW1haWwgaWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBlLW1h aWwgYnkgbWlzdGFr
ZSBhbmQgZGVsZXRlIHRoaXMgZS1tYWlsIGZyb20geW91ciBzeXN0ZW0uIEUt bWFpbCB0cmFuc21p
c3Npb24gY2Fubm90IGJlIGd1YXJhbnRlZWQgdG8gYmUgc2VjdXJlIG9yIGVy cm9yLWZyZWUgYXMg
aW5mb3JtYXRpb24gY291bGQgYmUgaW50ZXJjZXB0ZWQsIGNvcnJ1cHRlZCwg bG9zdCwgZGVzdHJv
eWVkLCBhcnJpdmUgbGF0ZSBvciBpbmNvbXBsZXRlLCBvciBjb250YWluIHZp cnVzZXMuIFRoZSBz
ZW5kZXIgdGhlcmVmb3JlIGRvZXMgbm90IGFjY2VwdCBsaWFiaWxpdHkgZm9y IGFueSBsb3NzIG9y
IGRhbWFnZSBjYXVzZWQgYnkgdmlydXNlcyBvciBlcnJvcnMgb3Igb21pc3Np b25zIGluIHRoZSBj
b250ZW50cyBvZiB0aGlzIG1lc3NhZ2UsIHdoaWNoIGFyaXNlIGFzIGEgcmVz dWx0IG9mIGUtbWFp
bCB0cmFuc21pc3Npb24uIFtGcmllbmRGaW5kZXIgTmV0d29ya3MsIEluYy4s IDIyMCBIdW1ib2x0
IGNvdXJ0LCBTdW5ueXZhbGUsIENBIDk0MDg5LCBVU0EsIEZyaWVuZEZpbmRl ci5jb20NCg==