"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 08/17/2017
03:13:13 PM:
Best practice is not to use SELECT *, always use an explicit column
list.

This applies to INSERT too...

Don't do

INSERT INTO mytable
SELECT <...>

Instead, use

INSERT INTO mytable (col1, col2, col3, <...>)
SELECT <...>


In principle, I agree with you (always use an explicit column
list). But, I wonder, isn't there a third choice?

INSERT INTO mytable
SELECT col1, col2, col3, ... FROM ...etc...

Sincerely,

Dave Clark

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].