MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From: Date:January 1 1970 12:00am
Subject:How to write subqueries?
Date: Tue, 14 Jun 2005 21:01:33 +0400
View as plain text  
Hello!

MySQL v. 4.1.11.
I'm trying to write a subquery, MySQL says "Error".

select num, theme, intro 
from vt_(select pnid from vt_partition where pnid regexp '^[0-9]{11}$') 
order by date desc, timer desc;

describe vt_parition:
+----------+--------------+------+-----+----------+----------------+
| Field    | Type         | Null | Key | Default  | Extra          |
+----------+--------------+------+-----+----------+----------------+
| num      | int(11)      |      | MUL | NULL     | auto_increment |
| partname | varchar(255) |      |     |          |                |
| pnid     | varchar(11)  |      |     |          |                |
| timer    | time         |      |     | 00:00:00 |                |
+----------+--------------+------+-----+----------+----------------+

describe vt_24411620611;
+-------+--------------+------+-----+------------+----------------+
| Field | Type         | Null | Key | Default    | Extra          |
+-------+--------------+------+-----+------------+----------------+
| num   | int(11)      |      | MUL | NULL       | auto_increment |
| login | varchar(10)  |      |     |            |                |
| mail  | varchar(35)  |      |     |            |                |
| theme | varchar(100) |      |     |            |                |
| intro | text         |      |     |            |                |
| text  | text         |      |     |            |                |
| date  | date         |      |     | 0000-00-00 |                |
| timer | time         |      |     | 00:00:00   |                |
+-------+--------------+------+-----+------------+----------------+

"vt_"  is a prefix, "pnid" is a postfix.
And the name of the table is, for expamle, vt_01234567890.

Where is/are the mistake(s) in my subquery?
Please explain me how to write a subquery in the right way.

-- 
Good luck!
Vladimir

Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
Thread
How to write subqueries?Unknown Sender14 Jun
  • Re: How to write subqueries?SGreen14 Jun
    • RE: How to write subqueries?Rhino14 Jun
  • RE: How to write subqueries?Rhino14 Jun
  • Re: How to write subqueries?mfatene14 Jun
    • Re: How to write subqueries?Unknown Sender14 Jun
      • Re: How to write subqueries?mfatene14 Jun
        • Table fullEmmett Bishop15 Jun
          • Re: Table fullmfatene15 Jun
            • Re: Table fullEmmett Bishop15 Jun
              • Re: Table fullmfatene15 Jun
                • Re: Table fullEmmett Bishop15 Jun
                  • Re: Table fullmos16 Jun
                    • Re: Table fullEmmett Bishop16 Jun
                      • Re: Table fullmfatene16 Jun
        • Re: How to write subqueries?Unknown Sender15 Jun
    • Re: How to write subqueries?Unknown Sender14 Jun