Insert Select question

[kschuster]

how can i use and insert select AND also insert additional data not included in the select

for example

insert into mytable (column1, column 2, column3)
(Select thiscolumn
From anotherTable), '1', now();

thanks

[Sxooter]

Originally posted by kschuster
how can i use and insert select AND also insert additional data not included in the select

for example

insert into mytable (column1, column 2, column3)
(Select thiscolumn
From anotherTable), '1', now();

thanks

It should work with the extra values in the parens as well.

insert into mytable (column1, column 2, column3)
(Select thiscolumn
From anotherTable, '1', now());

[kschuster]

No luck with that suggestion. BTW - I am using mysql 3

[Sxooter]

Yeah, that flavor of MySQL still doesn't support subselects.

Would work in MySQL 4.x and almost all other databases.

I'm sure there's some MySQL 3.x specific syntax that would work, but I don't know what it is. Anyone else?

[Lars_Berg]

insert into mytable (column1, column 2, column3)
Select thiscolumn, '1', now()
From anotherTable;

insert into mytable (column1, column 2, column3)
(Select thiscolumn
From anotherTable, '1', now());

will not work in any dbms.

insert into mytable (column1, column 2, column3)
values ((Select thiscolumn
From anotherTable), '1', now());

may work in some.

[Sxooter]

Yep, I forgot the values keyword. Thanks for the catch!