statement - MySQL Database

replay

hi together

i need to write an sql statement which follows a recursive dependency.
but i just dont get it to work as i want...:-) on the links at the
bottom is a graphical explanation of the table definition and how i want
to use it.

now i need a query with a where. for example, select all torrents which
are in category xy or in a subcategory of xy.

i know it would be easy to get a working solution with stored
procedures. but it would be much nicer to have it in one query.

http://www.h4xx0r.ch/db.jpg
http://www.h4xx0r.ch/tree.jpg
thanks for help
replay

--

visit: http://www.h4xx0r.ch

Dec 21 '05 #1

Subscribe Post Reply

1108

replay

maybe it would be helpful if you have my db to test...:-)

http://www.h4xx0r.ch/ts.sql

thanks
replay wrote:

hi together

i need to write an sql statement which follows a recursive dependency.
but i just dont get it to work as i want...:-) on the links at the
bottom is a graphical explanation of the table definition and how i want
to use it.

now i need a query with a where. for example, select all torrents which
are in category xy or in a subcategory of xy.

i know it would be easy to get a working solution with stored
procedures. but it would be much nicer to have it in one query.

http://www.h4xx0r.ch/db.jpg
http://www.h4xx0r.ch/tree.jpg
thanks for help
replay

--

visit: http://www.h4xx0r.ch

Dec 21 '05 #2

Similar topics

PEP new assert idiom

by: Fábio Mendes | last post by:

I'm sorry if it's an replicate. Either my e-mail program is messing with things or the python-list sent my msg to /dev/null. I couldn't find anything related in previous PEP's, so here it goes a...

Python

Return statement twice in the same expression

by: Nerox | last post by:

Hi, If i write: #include <stdio.h> int foo(int); int main(void){ int a = 3; foo(a); }

C / C++

"with" statement, extending prototype

by: eman1000 | last post by:

I was recently looking at the prototype library (http://prototype.conio.net/) and I noticed the author used the following syntax: Object.extend(MyObj.prototype, { my_meth1: function(){},...

Javascript

pre-PEP: The create statement

by: Steven Bethard | last post by:

The PEP below should be mostly self explanatory. I'll try to keep the most updated versions available at: http://ucsu.colorado.edu/~bethard/py/pep_create_statement.txt...

Python

updated pre-PEP: The create statement

by: Steven Bethard | last post by:

I've updated the PEP based on a number of comments on comp.lang.python. The most updated versions are still at: http://ucsu.colorado.edu/~bethard/py/pep_create_statement.txt...

Python

PEP 359: The "make" Statement

by: Steven Bethard | last post by:

Ok, I finally have a PEP number. Here's the most updated version of the "make" statement PEP. I'll be posting it shortly to python-dev. Thanks again for the previous discussion and suggestions!...

Python

Updated PEP 359: The make statement

by: Steven Bethard | last post by:

I've updated PEP 359 with a bunch of the recent suggestions. The patch is available at: http://bugs.python.org/1472459 and I've pasted the full text below. I've tried to be more explicit about...

Python

ASP Type mismatch error with SELECT...FOR UPDATE statement

by: Steve | last post by:

ASP error number 13 - Type mismatch with SELECT...FOR UPDATE statement I got ASP error number 13 when I use the SELECT...FOR UPDATE statement as below. However, if I use SELECT statement without...

ASP / Active Server Pages

Definition of expression and statement.

by: dspfun | last post by:

Hi! The words "expression" and "statement" are often used in C99 and C- textbooks, however, I am not sure of the clear defintion of these words with respect to C. Can somebody provide a sharp...

C / C++

statement values

by: florian.loitsch | last post by:

According to the spec Section 14 the production SourceElements:SourceElements SourceElement is evaluated as follows: 1. Evaluate SourceElements. 2. If Result(1) is an abrupt completion, return...

Javascript

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++