php - MYSQL insert data from one table to another? -

php - MYSQL insert data from one table to another? -

i have 2 tables , need add together value "user" table user table album user is.

table1 (user)

id_user auto_increase user password

table2 (album)

idalbum auto_increase title descripcion user text

insert `table2` select (null,"some title","some description",`user`) `table1` `id_user`="12345";`

this select username user 12345 table1 , insert table2.

php mysql sql insert