MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Marco Bresciani Date:March 3 2004 3:11pm
Subject:Re: Table selection
View as plain text  
Egor Egorov <egor.egorov@stripped> ha scritto:

>You can't do it only with MySQL. Retrieve table names from List table:
>	SELECT CONCAT("FX", Name) FROM List;
>
>and then use programming language to construct a query.

Thank you... I've supposed it...
What about using UNION? Something like:

SELECT * FROM FX5686 UNION SELECT * FROM FX5698 UNION ... WHERE [condition]

I obviously need a programming language to compose this query... but it
seems clearer to me... if it works!

Marco Bresciani

-- 
(o>  Utente SETI@Home da 3,632 anni (2200 unità)
//\  Tempo CPU: 2,238 anni (8h 54min 44s medio)
V_/_ Posizione: 111701/4900443 (97,72%)
Thread
Table selectionMarco Bresciani3 Mar
  • Re: Table selectionEgor Egorov3 Mar
  • Re: Table selectionMarco Bresciani3 Mar
    • Re: Table selectionEgor Egorov3 Mar