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
Err: Wrong Datatype (#Value will be displayed)
Err: Assistive technology support has been requested for this session ...
Err: unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in
Err: Call to a member function get_cellmap() on a non-object by sfDomPDFPlugin in Symfony
Restore plain dump file using console
Drupal PDO error : Invalid input syntax for integer
quicktime demuxer not found in Ubuntu 11.10
Turn USB write protect flag off
No comments:
Post a Comment