MySQL INSERT SELECT example

insert into user (id, name, email, passwd, ref, joindate) select idm, user_name, email, pass, refferal, sysdate() from db.members;

Thank you for reading this article MySQL INSERT SELECT example With URL http://x-tutorials.blogspot.com/2005/04/mysql-insert-select-example.html. Also a time to read the other articles.