insert into many tables with single query??

[leelong]

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!

[r937]

can i do it with just one query?

no