德育二维码设计SQL

德育二维码设计SQL

SELECT
CONCAT(
‘{“USERID”:"’,
ID,
‘",“姓名”:"’,
NAME,
‘",“学号”:"’,
IFNULL(NUMBER, ‘’),
‘",“证件号码”:"’,
CREDENTIAL_NUMBER,
‘"}’
) stu_info
FROM
PLATFORM_SYS_USER

SELECT
CONCAT(
‘{“USERID”:"’,
ID,
‘"}’
) stu_info
FROM
PLATFORM_SYS_USER

相关推荐
©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页