"SELECT 1 FROM (SELECT 1 FROM table) q" does not working on local machine

Posted by Qiao on Stack Overflow See other posts from Stack Overflow or by Qiao
Published on 2010-03-24T18:04:35Z Indexed on 2010/03/24 18:13 UTC
Read the original article Hit count: 281

Filed under:
SELECT 1 FROM (SELECT 1 FROM table) q

does not working on my local server. it returns totally nothing (no error or empty table).

But SELECT 1 FROM table is ok.

What is wrong with it? is there any MySQL option for such queries?

© Stack Overflow or respective owner

Related posts about mysql