off into the weeds

2003-11-28 Thread Dean A. Hoover
I am running mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) on redhat 9. I have defined a simple database as follows: DROP DATABASE IF EXISTS xhistory; CREATE DATABASE xhistory; USE xhistory; CREATE TABLE category ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, parent_id INT,

RE: off into the weeds

2003-11-28 Thread Bob Loeffler
it will take a lot of time. Bob -Original Message- From: Dean A. Hoover [mailto:[EMAIL PROTECTED] Sent: Friday, November 28, 2003 1:38 AM To: [EMAIL PROTECTED] Subject: off into the weeds I am running mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) on redhat 9. I have defined

Re: off into the weeds

2003-11-28 Thread Martijn Tonies
Hi Dean, I have populated the database, which has 6319 records in the list_rank table and 2472 records in the entry table. Everything looks fine, and I can easily do the simple queries such as: mysql select * from list_rank; However, when I run the following simple join, mysqld seems