1. 单个赋值 - 使用into
SELECT `name` INTO @name FROM table WHERE `id`=1 ;
2.多个赋值 - 直接赋值
SELECT @name:=`name`, @phone:=`phone` FROM table WHERE `id`=1 ;
1. 单个赋值 - 使用into
SELECT `name` INTO @name FROM table WHERE `id`=1 ;
2.多个赋值 - 直接赋值
SELECT @name:=`name`, @phone:=`phone` FROM table WHERE `id`=1 ;