[thelist] SQL Query Review
rudy at r937.com
Tue Apr 22 12:13:08 CDT 2008
>> also, an index on entryID would be wise
> But entryID is a PK. Would I still want to do that?
no, do not declare indexes for PKs, just for FKs, as well as for any
non-PK/FK columns used in a WHERE condition
> I have always used array positions. So in the example SQL,
> I would access it in PHP this way:
i don't do php, but i think you're leaving yourself open for disaster if you
ever change the sequence of the columns in the SELECT clause
>> FROM entries AS e
> ....but that threw me for a loop. What will that do for me?
it will give the alias "e" to the entries table
More information about the thelist