faqts : Computers : Databases : MySQL : Language and Syntax

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

7 of 43 people (16%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

I need to copy/clone rows in my tables. Does Mysql have a built-in function to do this?

Oct 21st, 2004 18:20
John Nunez, harvey buggiba,


Simple:
INSERT INTO MAILING_LIST SELECT EMAIL FROM CUSTOMBER_LIST