Category: >> mySQL >> Copy one table to another Bookmark and Share

<< lastnext >>

Snippet Name: Copy one table to another

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

Comment: (none)

Author: CoderZone
Language: MYSQL
Highlight Mode: MYSQL
Last Modified: February 28th, 2009

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 "; 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 6