Insert using select and values

[monkeyx]

Can anyone let me know if it possible to formulate an insert query
that that can use both select and values, so that I can get certain
data from the another table and have fixed values for some of the
fields in the insert query?

I guess one way would be to do an insert for select statement, then an
update for fixed values.

If it is possible will someone please post an example.

Thanks,

monkeyx

[gluck]

You can create some thing like this:

ex: you have table A with nameA and you wanna insert into nameB table B

Select concat("insert nameB into B values", nameA) From A;
it will print insert stmts for all available values and you can then run the result it in batch mode;

[fenway]

You can run an INSERT INTO ... SELECT WHERE, but only for existing records.