Re: how insert query with sub-select query?

[Barry Galbraith]

>i want to get the user_id using select


>so how i can do that ?

SELECT last_insert_id();

Like this.

insert into user(id,username,password,email) values (1,'user1',1234.'user@email');

insert into user_info(id,name,father_name,address,user_id) values (1,'user-name','user-father','H block',last_insert_id());

http://dev.mysql.com/doc/refman/5.6/en/information-functions.html#function_last-insert-id

Good luck,
Barry.