Tuesday, December 15, 2009

Selective insert from existing table

To insert entire fields,

INSERT
INTO
               emp_new
SELECT
               *
FROM
               emp_old


To insert selective fields,


INSERT
INTO
               emp_new (eno, age)
SELECT
               eno,
               age
FROM
               emp_old



No comments:

Post a Comment