Insert into multiple tables

vertmonkee

Is it possible to Insert data into multiple tables in a single squery.

e.g. can I do something like this.

INSERT INTO table1, table2 ('field1', 'field2', 'field3', field4') VALUES 'value1', 'value2', 'value3, 'value4';

where field 1 and 2 are properties of table 1 and are required to have values 1 and 2 inserted respectively.

Thanks

laserlight

Use two SQL statements:

INSERT INTO table1 (field1, field2, field3, field4) VALUES ('value1', 'value2', 'value3', 'value4');
INSERT INTO table2 (field1, field2, field3, field4) VALUES ('value1', 'value2', 'value3', 'value4');

Actually, why do you have two tables that are so alike?

vertmonkee

So itsnot possible to use one INSERT statement with multiple table?

I dont actually have tables that contain those details i just used it for an easy example

thanks for the help

laserlight

So itsnot possible to use one INSERT statement with multiple table?

As far as I know yes, it is not possible. Of course, some of the database gurus around here may offer a different opinion.

Shrike

vertmonkee wrote:
I dont actually have tables that contain those details i just used it for an easy example

But like Laserlight says you have more than one table but only one set of columns & values so you'll end up with duplicates.

You can do multiple inserts in one query, if thats what you need.

vertmonkee

Ok, to use a real example I have a form that will collect details about a location and also a table that holds details about the obstacles at the spot.

So for instance in one INSERT i would like to place the values 37 Main Street, Plymouth, Devon into the fields address_line_1, town, county which are in the location table.

And then into the obstacles table I wish to place the values handrail, medium, 5 steps into the fields obstacle_description, obstacle_size, obstacle_number.

Does this make it any clearer?

Thanks very much.

Shrike

If I get what you mean, you want to list a number of tables and columns, and have the database know which columns are meant for which table. Which, afaik, is not possible. Your looking at using as many inserts as there are tables.