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
Err: Call to a member function get_cellmap() on a non-object by sfDomPDFPlugin in Symfony
Err: No entry for terminal type "unknown"; using dumb terminal settings.
Bulk Convert Office Documents into PDF using unoconv
PDOException: Invalid text representation
quicktime demuxer not found in Ubuntu 11.10
Err: Unlock Login Keyring in Ubuntu 11.10 problem
Internal field separator (IFS) for shell scripts
Disable the password window asked everytime in PgAdmin
Postgresql 9.x to 8.x restore issue with bytea field contains hex values
Err: apt-get update not working
No comments:
Post a Comment