when we create a new record in sugar the fields will be inserted into two or more table how this can be achieved from MySQL query

Question

when we create a new record in sugarcrm the fields will be inserted into two or more table how this can be achieved from MySQL query

i have two tables a_vendor(id,name) and a_vendor_cstm(id_c,email_c) i need to insert into two table at the same in order to have same id as

insert into a_vendor (id,name) values (auto_generated,'myname');
insert into a_vendor (id_c,email_c) values (auto_generated_same_as_id,'my email');

That seems risky if you are relying solely on inserting at the same time. Better yet to perform the first insert, retrieve the `id` generated and perform the second insert. You can use `SELECT LAST_INSERT_ID()` to get the last autogenerated ID from your session after running the first `INSERT`. — JNevill, Mar 24 '17 at 13:32
http://stackoverflow.com/questions/175066/sql-server-is-it-possible-to-insert-into-two-tables-at-the-same-time — lady_bird, Mar 24 '17 at 13:36

score 2 · Accepted Answer · answered Mar 24 '17 at 13:42

2

well i found it thanks for your help the query is as :

START TRANSACTION;

SET @id= uuid();

INSERT INTO a_vendor(id,name) VALUES (@id,'mynqme');

INSERT INTO a_vendor_cstm(two_id, name) VALUES (@id, 'email');

COMMIT;

answered Mar 24 '17 at 13:42

Mohammad Yaseer

148
13

But this is not a prefer way to do it. – Amitesh Kumar Mar 25 '17 at 18:46
amitesh Kumar then ? glad if you share the query... :) – Mohammad Yaseer Mar 28 '17 at 14:31
http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.7/Data_Framework/Database/SugarQuery/ – Amitesh Kumar Mar 29 '17 at 05:15
Thanks for that reference :) – Mohammad Yaseer Mar 29 '17 at 12:29

when we create a new record in sugar the fields will be inserted into two or more table how this can be achieved from MySQL query

1 Answers1