select user_id,user_name into @USER_ID,@USER_NAME from user where user_id=1;
select @USER_ID,@USER_NAME;
select * from user_subject where user_id=@USER_ID;
select user_id,user_name into @USER_ID,@USER_NAME from user where user_id=1;
select @USER_ID,@USER_NAME;
select * from user_subject where user_id=@USER_ID;