set variable to count of rows in mysql

Question

This isn't a complete question, but I was just wondering if there was a better or more elegant way to set a variable to the count of the number of rows from a mysql select statement. Currently, what I have is:

SET @myCount = 
(SELECT COUNT(*) 
FROM table1
WHERE aCondition = TRUE);

Raphaël Althaus · Accepted Answer · 2014-07-10 16:36:16Z

1

you can use a select... into (donnow if you find this more "elegant")

select count(*) into @myCount
from table1
where aCondiction = TRUE;

answered Jul 10, 2014 at 16:36

Raphaël Althaus

60.6k6 gold badges106 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

set variable to count of rows in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related