<div>
Sure you may provide the name of the columns in the select list<br />
<br />
Select col1, col2, col3, .... coln<br />
from TableName<br />

</div>


Sure you may provide the name of the columns in the select list

Select col1, col2, col3, .... coln
from TableName


<div>
It is definitely more efficient to select only those columns you are going to use. <br />
<br />
If you doubt, you can set up a quick benchmark recording the time before and after queries, and see how much better.
</div>


It is definitely more efficient to select only those columns you are going to use.

If you doubt, you can set up a quick benchmark recording the time before and after queries, and see how much better.

<div>
@angelIII: very well put! ~Ray
</div>


<div>
&gt;it's like you would buy an entire library, just to get 3-4 books you want to read.<br />
additionally, developers doing this kind of code (select *) are then the ones complaining about network being slow and the like :/<br />
<br />
glad to be of assistance ...
</div>


>it's like you would buy an entire library, just to get 3-4 books you want to read.
additionally, developers doing this kind of code (select *) are then the ones complaining about network being slow and the like :/

glad to be of assistance ...

<div>
Yep, I just changed the select * to just the few columns I needed and its an AMAZING difference...this sure beats the cost of the upgraded server the sales rep was trying to &quot;upgrade&quot; us to...ha!
</div>


Yep, I just changed the select * to just the few columns I needed and its an AMAZING difference...this sure beats the cost of the upgraded server the sales rep was trying to "upgrade" us to...ha!

<div>
Bet you paid for your EE membership right there!<br />
<br />
If you're looking for even more speed, you can try making those selection fields into indexes.<br />
<br />
Warm regards, ~Ray
</div>


Bet you paid for your EE membership right there!

If you're looking for even more speed, you can try making those selection fields into indexes.

Warm regards, ~Ray

<div>
<div class="content wysiwyg-content">
I have a table with close to 100 columns that I am currently doing a select * on.<br />
<br />
Is it better to only select the columns I need?<br />
<br />
Instead of the SELECT * how do I name individual column in the the query? &nbsp;SELECT columna, columnb, columnc ?
</div>
</div>


I have a table with close to 100 columns that I am currently doing a select * on.

Is it better to only select the columns I need?

Instead of the SELECT * how do I name individual column in the the query?  SELECT columna, columnb, columnc ?

PHP SQL Syntax with MySQL question

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.