On Saturday, December 8, 2001, at 12:53 PM, Arjen G. Lentz wrote:
Re-order the list of tables in the FROM, and put the
subprojectweb.subproject_name = 'shoeshine.com' bit first
after the WHERE, that will also make it clearer for you to read.
Is this just for my own personal clarity? I
Hi Erik,
- Original Message -
From: Erik Price [EMAIL PROTECTED]
I see. If I mentally apply this advice to the rest of my database, it
seems that I should index (or apply a prefix index) to any column that
holds search criteria -- such as files.file_name or
http://www.tums.com
On Friday, December 7, 2001, at 06:58 AM, Erik Price wrote:
On Thursday, December 6, 2001, at 08:35 PM, Arjen G. Lentz wrote:
There is also the one part that limits your selection (shoeshine.com).
So that
is very important. I've quoted the table structure of the
I haven't populated this database yet. There are actually many more
columns, this was kind of a rough draft -- I only featured the ones that
I needed to see if my JOINs were okay. I just got a little nervous when
I drafted a few sample queries and saw that much text !!
That makes me feel
Hi Erik,
- Original Message -
From: Erik Price [EMAIL PROTECTED]
mysql SHOW COLUMNS FROM subprojectweb;
+-+---+--+-+-+
| Field | Type | Null | Key | Default |