How do I store a value from a SELECT statement in a variable in a MySQL Stored Procedure? December 26, 2023 by Tarik In a stored procedure do this: SELECT COUNT(barcode) AS count into @myVar FROM movieitems;