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
Thunderbird: import or using of saved or backup folder in new instance in Linux
Crosstab based total calculation
Passing data as object between Views
Refresh system settings from sysctl.conf without restart Linux
Make files as undelete-able or non-editable
Port 80 is already used by another program in windows
Timeout error while signup new user in Drupal 6
Turn USB write protect flag off
Flash Builder 4
No comments:
Post a Comment