CREATETABLE`c_classuser_tab`(
`Id`int(11)NOTNULLAUTO_INCREMENT,
`Classid`int(11)DEFAULTNULL,
`Username`varchar(100)DEFAULTNULL,
`studentid`varchar(100)DEFAULTNULL,
`College`varchar(100)DEFAULTNULL,
`Department`varchar(100)DEFAULTNULL,
`Email`varchar(100)DEFAULTNULL,
`Phone`varchar(100)DEFAULTNULL,
`Status`int(11)DEFAULTNULL,
`Remark1`varchar(100)DEFAULTNULL,
`Remark2`varchar(100)DEFAULTNULL,
`Remark3`varchar(100)DEFAULTNULL,
`activateTime`datetimeDEFAULTNULL,
`joinTime`datetimeDEFAULTNULL,
`userID`int(11)DEFAULTNULL,
`userType`int(11)DEFAULTNULL,
PRIMARYKEY(`Id`),
KEY`C_classuser_tab_index`(`studentid`),
KEY`idx_classuser_complex`(`Classid`,`userID`)
)ENGINE=MyISAMAUTO_INCREMENT=31091DEFAULTCHARSET=utf8;
同一ID的老师有多个代课的班级,将其合并,
教师代课班级
121班,2班
复制代码代码如下:
selectUsername,GROUP_CONCAT(Remark1,'')asclassesfromc_classuser_tabwhereuserID=*anduserType=*
|