Is it possible to do multiple SELECT INTO?

Question

MySQL

Допустим есть:
DECLARE _balance INT(11);
DECLARE _balance2 INT(11);

SELECT `balance` INTO _balance FROM `users` WHERE `id` = `NEW`.`user_id` LIMIT 1;

We take the value of the variable _balance from the table users, but what if we need to take several columns at once? That is balance, balance2
something like:

SELECT `balance` INTO _balance, `balance2` INTO _balance2 FROM `users` WHERE `id` = `NEW`.`user_id` LIMIT 1;

Answer 1

DECLARE _balance INT(11);
DECLARE _balance2 INT(11);

SELECT `balance`, `balance2` INTO _balance, _balance2 
FROM `users` WHERE `id` = `NEW`.`user_id` LIMIT 1;

Details: dev.mysql.com/doc/refman/5.7/en/select.html