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?
views:
66answers:
2
+1
A:
Without really being able to understand what you're wanting to achieve, the solution to this problem is:
SELECT 1 FROM (SELECT 1) q;
Andy
2010-03-24 18:12:09
it is working. returns 1
Qiao
2010-03-24 18:14:43
is that what you wanted?
Andy
2010-03-24 18:15:57
I found it. `SELECT 1 FROM (SELECT 1 FROM table) AS q` is working. AAAASSSSS. AS on some servers matters.
Qiao
2010-03-24 18:17:30
AS is optional (according to MySQL 5.0 docs at least), even though the MySQL documents suggest you use AS.
Frank Shearar
2010-03-24 18:19:17
did you insert a row into (the previously empty) `table` by any chance? :)
Andy
2010-03-24 18:19:53
no i spend one hour for figuring this. `SELECT 1 FROM (SELECT 1 FROM ruch) q` does not working. `SELECT 1 FROM (SELECT 1 FROM ruch) AS q` is ok.
Qiao
2010-03-24 18:21:52
A:
Assuming that you have a table called "table", the SQL's fine. In my own database:
mysql> select 1 from (select 1 from ui_towngrpcolour) foo;
+---+
| 1 |
+---+
| 1 |
| 1 |
| 1 |
+---+
3 rows in set (0.00 sec)
Frank Shearar
2010-03-24 18:18:31
yes its ok. But in my local server only `AS foo` is working. Without `AS` it is not working.
Qiao
2010-03-24 18:20:08