copy data

[[deleted]]

hi everybody,

I want to copy the data from one to 

another table, i want to copy all the fields
accept the one field.The fields is AUTO_INCREMENT and i want to autoincrement while inserting the data.

table 1

memberID
title
firstname
lastname
gender

table2

memberID
title
firtname
lastname
gender

thanks in advance

[bfranco]

this may work:

INSERT INTO table2(title, firstname, lastnae, gender) SELECT title, firstname, lastnae, gender FROM table 1;

you'll find more info at: http://www.mysql.com/doc/I/N/INSERT_SELECT.html