On a related note, select * should generally not be used in production code. You either know what columns you want, or you don't. If you do, specify them, if not, ask yourself why am i writing this statement.
Spelling out columns: produces self-documenting statements, prevents errors due to column order change, avoids redundant data transfer of unused column data, and avoids redundant table fetches (if the index has all the required data).
select * is best used in ad-hoc queries and exists() clauses, where the actual column data and order do not matter..
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|