1.如果在向导设置班级数为8时,此数值为班级总数,所
以添加录入班级时,请检查1至8个班级是否已全部录入,如果
数据是经过导入而来,在保存前请将班级数大于8的数据删除.
2.在保存新数据前,请将多余的空数据删除.
3.对于无考试分数的学分只能用0来输入,不可用空.
4.学籍中,打勾表示在籍生,不打勾则表示编外生。
保存之前检查数据录入是否符合条件,否则统计报表将会出错!-1. If the wizard set up for 8 o
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001483s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.084311s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001150s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001207s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001003s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003214s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000911s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003964s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015394s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001186s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 194306 [ RunTime:0.288336s ]