Re: Zip Code & Distance

2006-08-29 Thread barney
Jesse, Back around 1995-1996 I built a VB app with an Access database that would do much of what you want - it was for shipping and terminal locations - then ported it over to ASP & SQL Server a year or two later. I found several raw data files, either CSV or TSV, which were pretty easily impo

A different authentication question ...

2006-03-18 Thread barney
Folk, Just installed MySQL 4.1.14 on a new Windows XP Pro system - this is a development system, no domain. Also installed PHP 4.3.11 and Apache 2.0.55. so now I have WAMP, right? Apache works fine as the web server; PHP works fine, as well. As soon as I tried to access databases created wit

Re: A different authentication question ...

2006-03-18 Thread barney
#x27;t I think of that?" head smacks . Make a good day ... ... barn > Barney > Dumb question, but is this in response to the error message you got > where at the end of the error it asks you to "update your client > program"? If so it is referring

Find records not in many-to-many table?

2006-03-25 Thread barney
Folk, This may be off-base for this list, but I've run out of places to look, sorry. I can't seem to find this anywhere, although I'm certain I've seen it before. How can I identify all the records in a table that are not referenced in a many-to-many table? I have a [unique] table of files an

Re: Find records not in many-to-many table?

2006-03-25 Thread barney
ies if I'm being dense. Make a good day ... ... barn > Use > select first_table.id from first_table left join second_table using (id) where > second_table.id is null > Stefan > Am Saturday 25 March 2006 19:10 schrieb barney: > > Folk, > > &g

Re: Find records not in many-to-many table?

2006-03-25 Thread barney
ELETEs are those files with no existing attribute. > HTH & YMMV > On 3/25/06, barney <[EMAIL PROTECTED]> wrote: > Folk, > This may be off-base for this list, but I've run out of places to look, > sorry.  I can't seem to find this anywhere, although I'm cert

Do foreign keys affect query speed?

2006-04-12 Thread barney
That's the whole question. Do foreign keys (FKs) affect query speed? 'Course the answer could lead to sub-questions , e.g., "If so, how best to optimize a query for them?" And I guess a corollary question would be whether implementing FKs slows down MySQL processing in general, but that can pro

Do foreign keys affect query speed?

2006-04-12 Thread barney
That's the whole question. Do foreign keys (FKs) affect query speed? 'Course the answer could lead to sub-questions , e.g., "If so, how best to optimize a query for them?" And I guess a corollary question would be whether implementing FKs slows down MySQL processing in general, but that can pro