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
Err: apt-get update not working
Err: Couldn't open header file ...
Flash Builder 4
Wordpress to Blogger migration too easy..
Bulk rename using bash rename command
CentOS: PHP PEAR and Symfony installation using source package
To know about the file type and its environment
Selective cell protection in Spreadsheet
Enable services at different runlevel
No comments:
Post a Comment