德育二维码设计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