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: No entry for terminal type "unknown"; using dumb terminal settings.
Err: WebGL not worked with Chrome 15 in Ubuntu 11.10
Err: unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in
Add day, month and year with date field
Compile shell scripts to encrypted binaries using SHC
Disable header and footer lines printed with web pages in Firefox
Repeatable file changes made easy with SED command in Linux
Bulk Convert Office Documents into PDF using unoconv
Custom access denied error page for sites/default/files url in Apache
No comments:
Post a Comment