SELECT * vs. SELECT field, field, field
| From: | olinux | Date: | Thu, 15 Mar 2001 10:13:00 +0000 |
| Subject: | SELECT * vs. SELECT field, field, field | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7504@lists.php.net to get a copy of this message | ||
A quick question, which executes faster ?
Suppose i have a table with 6 fields and I need to use all of the info in the table,
SELECT * FROM $table_name WHERE id = \"$id\"
or
SELECT field1, field2, field3, field4, field5, field6 FROM $table_name WHERE id = \"$id\"
I understand that they do the same thing. Just wondered if there is a difference in execution
speeds. I realize that its probably trivial, but I'm curious.
thanks
olinux