How to store Query Result in variable using mysql

December 26, 2022 by Tarik

Surround that select with parentheses.

SET @v1 := (SELECT COUNT(*) FROM user_rating);
SELECT @v1;