insert using select

say i have table_1 with fields a, b & c
and i have table_2 with fields a, b & d

i want to populate fields a & b of table 2 from records in table 1. in this case, i use:

INSERT INTO table_2 (a, b)
SELECT table_1.a, table_1.b FROM table_1

but if i do the above, field d of table_2 will always be blank.

how do i solve the problem if i want to populate field d of table_2 with a constant value of "hello" ?

thanks for your time.

 

Why would you like to do that?

p.l.u.r.

 

INSERT INTO table_2 (a, b, d)
SELECT table_1.a, table_1.b, "hello" FROM table_1

 

yeah... thanks! i just found out from a programmer friend...

thanks!