Skip to content

Instantly share code, notes, and snippets.

@managai

managai/gist:1344835

Created November 7, 2011 12:39
Show Gist options
  • Save managai/1344835 to your computer and use it in GitHub Desktop.
Save managai/1344835 to your computer and use it in GitHub Desktop.
Download ZIP
(SQL) copy data between tables
Raw
gistfile1.sql
insert
into table2
select *
from table1
#########
insert
into table2
( col1
, col2
, col3 )
select field3
, ( field7 + field8 ) * 9.37
, 0
from table1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment