Your Ad Here

advanced code snippet search

Posted By

tclancy on 06/26/10


Tagged

db


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

jatkins
dantreacy


INSERT from other table

 / Published in: MySQL
 

URL: http://www.mark-holt.co.uk/2008/11/18/howto-mysql-insert-data-from-one-table-to-another-table/

Expand | Embed | Plain Text 
  1. INSERT INTO tablename (colomn1, colomn2 ...)
  2. SELECT colomn1, colomn2 ...
  3. FROM tablename;

Report this snippet  

You need to login to post a comment.