Page 1 of 1

insert identification or id?

Posted: Thu Jun 21, 2012 1:25 am
by jayson.ph
Hi all,

i have two tables, btl_1 and tbl_2.

in tbl_1-> i have id,name and fname which is already have a record. while in tbl_2-> i have id,address and school. which is no record yet. and now how can i get the id from tbl_1 into tbl_2,

please help.. very needed

Re: insert identification or id?

Posted: Thu Jun 21, 2012 2:11 am
by pbs
Use mysql INSERT_ _ _ _SELECT query

Refer : http://dev.mysql.com/doc/refman/5.0/en/ ... elect.html