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: Unlock Login Keyring in Ubuntu 11.10 problem
Installing of Windows7 using USB / Pen drive like Linux
Installing PostgreSQL from source in Linux
General keyboard shortcuts
Err: Call to a member function get_cellmap() on a non-object by sfDomPDFPlugin in Symfony
Apache authentication and authorization using LDAPS
Bulk rename using bash rename command
Installing and using of libpdf in windows and linux
PostgreSQL console commands
Enable or disable the automatic user logins
No comments:
Post a Comment