ac senthilkumar's blog
________________________________________________________________________________________
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Popular Posts
Download cached flash videos of Firefox and Chrome in Linux(Ubuntu)
Err: Unlock Login Keyring in Ubuntu 11.10 problem
Importing of VCF contacts into Android Phones
quicktime demuxer not found in Ubuntu 11.10
Div tag alignment problem in Drupal
Restore plain dump file using console
Override the 'Maximum post viewed' error in indianidiots.com
PHP-Java bridge drawbacks
Removing Duplicate Rows in Open Office Calc
Internet Images
No comments:
Post a Comment