19 Jan
2011
19 Jan
'11
3:57 p.m.
I pondered on Simon Kariri's post and remembered postgre has similar functionality. Then i checked out the postgre documentation I found a simple solution to sort it out in 2 queries! Haven't checked for MySQL since i'm using PgSQL 1 Insert to table 1 and get the primary key in ONE QUERY *PGresult* result = PGquery(*"INSERT INTO TABLE1 (table_1_id,some_column) VALUES (DEFAULT, 'value flani')* RETURNING table_1_id**");* 2 Insert to table 2 using the returned result from the previous query** *PGquery(*"INSERT INTO TABLE2 (table_2_id,some_other_column, table_1_id) VALUES (DEFAULT, 'value flani',"*+ PQgetvalue(result, 0, 0) +*")"*);* Fast and Simple! No programming overhead