Copy one table to another

Submitted by:Jhon Smith

Date added:14 August, 2014

Category:MySQL

Easy way to copy the contents of one table to another table.

Tags: copy contents , copy table content

Code Snippet:

INSERT  INTO new_quotes 

SELECT SUBSTRING( quoteid, 0, 0 ) , TYPE ,
QUOTE, rating, DATE, title, hits, catid,
submit_date, userid, author, lifespan, cat_name

FROM quotes WHERE quoteid <> ''

ORDER BY quoteid LIMIT 50 ";
 
 

Comments