let’s go straight, say i have many diff tables and want to insert datas to all:–
INSERT INTO table_one VALUES('val_1', 'val_2', 'val_3')
INSERT INTO table_two VALUES('val_5', 'val_6', 'val_7', 'val_8')
INSERT INTO table_three VALUES('val_9', 'val_10')
INSERT INTO table_four VALUES('val_11', 'val_12', 'val_13', 'val_14', 'val_15')
.
.
.
.
this is too many round trip to DB server.
can i do it with just one query?
of course, if only one same table i can make one query like below:–
INSERT INTO table_one VALUES('val_1', 'val_2', 'val_3'), ('val_5', 'val_6', 'val_7', 'val_8'), ('val_9', 'val_10'), ('val_11', 'val_12', 'val_13', 'val_14', 'val_15')
thank you very much!
