MySQL multiple query

Question

I want to count records of query. The problem is that the query is not constant.

I write something like this, but this is only almost good

select count(*) from (select * from users);

where the select * from users is only example

I think something about this:

String query = "select * from users";
String queryCount = "select count(*) from ("  + query + ")";

This is not correct as in mysql query they wrote an error like this:

ERROR 1248 (42000): Every derived table must have its own alias

What is the correct command for that?

So give the derived table an alias – Strawberry Aug 25 '16 at 13:07 — Strawberry, Aug 25 '16 at 13:07

score 1 · Accepted Answer · answered Aug 25 '16 at 13:08

1

Try this:

 select count(*) from (select * from users) as alias;

there needs to be some name for result set that is generated by the query in brackets.

answered Aug 25 '16 at 13:08

Danyal Sandeelo

1 Answers1