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
Download cached flash videos of Firefox and Chrome in Linux(Ubuntu)
Compile shell scripts to encrypted binaries using SHC
SQL formatting tool online
Err: unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in
Err: gateway.php not found while executing Flex application for PHP
Setting up default print page orientation in firefox
Internal field separator (IFS) for shell scripts
Selective cell protection in Spreadsheet
Bulk Convert Office Documents into PDF using unoconv
No comments:
Post a Comment