Sorted Data
CREATE ROCEDURE `uspUserSetting`(
userId int
)
BEGIN
select as.UId, as.JoinTime,
as.PhoneNumber, as.Gender,
as.Nationality, as.EmailAddr,
as.DepositLevel, as.TopUpAmount
from app_setting as as
where as.UId = userId
order by TableId Asc;
/* this sp is created by Vivy on 2020.0605 */
/* add sorted feature on 2020.0605 */
END