Assign query results to variables and select all variables in resultset

Asked Feb 09 '14 at 23:47

Active Feb 10 '14 at 00:15

Viewed 211 times

I have five queries, each returning count for a specific criteria which is stored into local variables. I need all the variables into one resultset.

It looks working fine in MYSQL but getting exception when retrieving form c#

SET @Totalcount := (SELECT COUNT(*) FROM Images WHERE ImageID > 9 AND name='abc') ;

SET @subTotal := (SELECT COUNT(*) FROM Images WHERE ImageID< 100 AND name='xyz');

SELECT @Totalcount , @subTotal;

Exception: ERROR [42000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.16-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @subTotal := (SELECT COUNT(*) FROM Images WHERE ImageID=1 AND name' at line 2

What I am doing wrong? I am new to mysql so not sure what is the problem.

edited Feb 09 '14 at 23:58

asked Feb 09 '14 at 23:47

Munawar

2,588
2
26
29

Try to separate queries by semicolon. – Hamlet Hakobyan Feb 09 '14 at 23:55
1

`SELECT (SELECT COUNT(*) ...) AS totalcount, (SELECT COUNT(*) ... ) AS subtotal ...` – zerkms Feb 09 '14 at 23:59
I had used in actual query but missed in the above post. I just updated the question to include the semicolons though it did not work for me. – Munawar Feb 09 '14 at 23:59
no difference, same error – Munawar Feb 10 '14 at 00:04
sorry, you was right. I just could not follow above syntax. – Munawar Feb 10 '14 at 00:13

Assign query results to variables and select all variables in resultset

0 Answers0