insert and select

[Mushroom]

i want to insert data partially selected from another table.

insert into table (id_1,id_2) values ('1','data selected from others')

how to do it?

[laserlight]

Well, a simple solution would be say, to run a query and store the data from the other table in a variable, then run another query using this variable to insert the data into the table in question.

[Mushroom]

i am afraid no one will ignore this method.but its not efficient.

[laserlight]

well, it may not be all that efficient as in it uses more than 1 query to create a new row, but then you'll probably be doing the transfer only once per set of data.

[pete_bisby]

Try the following:

INSERT table_name (field_1, field_2, ..., field_n)
SELECT field_a, field_b, ..., field_x
FROM tables ...

Basically, it's an INSERT statement with a SELECT query instead of VALUES, and it keeps your number of SQL queries down to a minimum.