Manish,
On Mon, Dec 14, 2009 at 05:33:43PM +0530, Manish Ranjan wrote:
I am using mysql 5.0.77 on RHEL 5. Storage engine in MyISAM.
Please refer to the below two statements. First query is checking for
lastname 'clarke' where as second query is checking for lastname 'clark'.
Rest
Hi Olga,
On Thu, Oct 29, 2009 at 03:29:58PM +, Olga Lyashevska wrote:
I have a table which contains taxonomic data (species, genera, family,
order, class) and it is organized as adjacency list model.
mysql select* from taxonomic_units1 limit 5;
On Thu, Oct 29, 2009 at 07:53:25PM +0300, Sergey Petrunya wrote:
... taxonomic_units1 AS O1
LEFT OUTER JOIN taxonomic_units1 AS O2
ON O1.tsn = O2.parent_tsn
current optimizer has only one option(*): use Nested-Loops Join algorthm, with
the outer table being the first one