transfer data from a query to another

[gonny]

Hi all!
I need to transfer my data from a query to another.
SELECT memid, name FROM friends
to
INSERT INTO members (memberid, memname) VALUES (memid, name)

I use "while" in query but this operation repeat many times. HOW can insert without dublicates? Or insert data if already not exist?

[blang]

You mean you want to do something like this:

INSERT INTO members 
 (memberid,memname) 
SELECT memid,name FROM friends 
; 

Take a look at the INSERT ... SELECT statement syntax [dev.mysql.com] (assuming you're using MySQL here of course!).